Dataset statistics
| Number of variables | 43 |
|---|---|
| Number of observations | 198910 |
| Missing cells | 2246072 |
| Missing cells (%) | 26.3% |
| Duplicate rows | 100 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 352.2 MiB |
| Average record size in memory | 1.8 KiB |
Variable types
| Text | 10 |
|---|---|
| Numeric | 13 |
| Categorical | 9 |
| DateTime | 7 |
| Boolean | 4 |
Structural Notification has constant value "True" | Constant |
Voluntary Soft-Story Retrofit has constant value "True" | Constant |
Fire Only Permit has constant value "True" | Constant |
Site Permit has constant value "True" | Constant |
| Dataset has 100 (0.1%) duplicate rows | Duplicates |
Estimated Cost is highly overall correlated with Revised Cost | High correlation |
Existing Construction Type is highly overall correlated with Number of Existing Stories and 2 other fields | High correlation |
Existing Construction Type Description is highly overall correlated with Proposed Construction Type and 1 other fields | High correlation |
Existing Units is highly overall correlated with Proposed Units | High correlation |
Neighborhoods - Analysis Boundaries is highly overall correlated with Supervisor District and 1 other fields | High correlation |
Number of Existing Stories is highly overall correlated with Existing Construction Type and 1 other fields | High correlation |
Number of Proposed Stories is highly overall correlated with Existing Construction Type and 1 other fields | High correlation |
Permit Type is highly overall correlated with Permit Type Definition | High correlation |
Permit Type Definition is highly overall correlated with Permit Type | High correlation |
Plansets is highly overall correlated with Street Number Suffix | High correlation |
Proposed Construction Type is highly overall correlated with Existing Construction Type Description and 1 other fields | High correlation |
Proposed Construction Type Description is highly overall correlated with Existing Construction Type Description and 1 other fields | High correlation |
Proposed Units is highly overall correlated with Existing Units | High correlation |
Revised Cost is highly overall correlated with Estimated Cost | High correlation |
Street Number Suffix is highly overall correlated with Existing Construction Type and 1 other fields | High correlation |
Supervisor District is highly overall correlated with Neighborhoods - Analysis Boundaries and 1 other fields | High correlation |
Zipcode is highly overall correlated with Neighborhoods - Analysis Boundaries and 1 other fields | High correlation |
Permit Type Definition is highly imbalanced (83.5%) | Imbalance |
Street Number Suffix is highly imbalanced (59.2%) | Imbalance |
Street Suffix is highly imbalanced (69.9%) | Imbalance |
Current Status is highly imbalanced (60.4%) | Imbalance |
Existing Construction Type Description is highly imbalanced (60.4%) | Imbalance |
Street Number Suffix has 196694 (98.9%) missing values | Missing |
Street Suffix has 2768 (1.4%) missing values | Missing |
Unit has 169430 (85.2%) missing values | Missing |
Unit Suffix has 196949 (99.0%) missing values | Missing |
Issued Date has 14942 (7.5%) missing values | Missing |
Completed Date has 101715 (51.1%) missing values | Missing |
First Construction Document Date has 14948 (7.5%) missing values | Missing |
Structural Notification has 191988 (96.5%) missing values | Missing |
Number of Existing Stories has 42788 (21.5%) missing values | Missing |
Number of Proposed Stories has 42871 (21.6%) missing values | Missing |
Voluntary Soft-Story Retrofit has 198875 (> 99.9%) missing values | Missing |
Fire Only Permit has 180082 (90.5%) missing values | Missing |
Permit Expiration Date has 51884 (26.1%) missing values | Missing |
Estimated Cost has 38068 (19.1%) missing values | Missing |
Revised Cost has 6066 (3.0%) missing values | Missing |
Existing Use has 41117 (20.7%) missing values | Missing |
Existing Units has 51543 (25.9%) missing values | Missing |
Proposed Use has 42441 (21.3%) missing values | Missing |
Proposed Units has 50915 (25.6%) missing values | Missing |
Plansets has 37311 (18.8%) missing values | Missing |
TIDF Compliance has 198908 (> 99.9%) missing values | Missing |
Existing Construction Type has 43369 (21.8%) missing values | Missing |
Existing Construction Type Description has 43370 (21.8%) missing values | Missing |
Proposed Construction Type has 43165 (21.7%) missing values | Missing |
Proposed Construction Type Description has 43165 (21.7%) missing values | Missing |
Site Permit has 193550 (97.3%) missing values | Missing |
Estimated Cost is highly skewed (γ1 = 80.2643549) | Skewed |
Revised Cost is highly skewed (γ1 = 108.7016029) | Skewed |
Plansets is highly skewed (γ1 = 400.8420748) | Skewed |
Existing Construction Type is highly skewed (γ1 = 35.25093762) | Skewed |
Unit has 21411 (10.8%) zeros | Zeros |
Revised Cost has 8514 (4.3%) zeros | Zeros |
Existing Units has 29135 (14.6%) zeros | Zeros |
Proposed Units has 26885 (13.5%) zeros | Zeros |
Plansets has 63247 (31.8%) zeros | Zeros |
Reproduction
| Analysis started | 2024-08-29 16:15:05.020351 |
|---|---|
| Analysis finished | 2024-08-29 16:16:09.687095 |
| Duration | 1 minute and 4.67 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
Permit Number
Text
| Distinct | 34484 |
|---|---|
| Distinct (%) | 17.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.7 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.181952 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2025292 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 31975 ? |
|---|---|
| Unique (%) | 16.1% |
Sample
| 1st row | M394467 |
|---|---|
| 2nd row | 2.01505E+11 |
| 3rd row | M798247 |
| 4th row | 2.01308E+11 |
| 5th row | 2.01307E+11 |
| Value | Count | Frequency (%) |
| 2.01709e+11 | 3549 | 1.8% |
| 2.01708e+11 | 3424 | 1.7% |
| 2.01406e+11 | 3092 | 1.6% |
| 2.01603e+11 | 2984 | 1.5% |
| 2.01503e+11 | 2982 | 1.5% |
| 2.01706e+11 | 2969 | 1.5% |
| 2.01506e+11 | 2944 | 1.5% |
| 2.01705e+11 | 2935 | 1.5% |
| 2.01609e+11 | 2927 | 1.5% |
| 2.01504e+11 | 2914 | 1.5% |
| Other values (34474) | 168190 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 561084 | |
| 0 | 304396 | |
| 2 | 206496 | 10.2% |
| . | 161645 | 8.0% |
| E | 161645 | 8.0% |
| + | 161645 | 8.0% |
| 7 | 92993 | 4.6% |
| 6 | 71859 | 3.5% |
| 4 | 67853 | 3.4% |
| 5 | 64530 | 3.2% |
| Other values (4) | 171146 | 8.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2025292 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 561084 | |
| 0 | 304396 | |
| 2 | 206496 | 10.2% |
| . | 161645 | 8.0% |
| E | 161645 | 8.0% |
| + | 161645 | 8.0% |
| 7 | 92993 | 4.6% |
| 6 | 71859 | 3.5% |
| 4 | 67853 | 3.4% |
| 5 | 64530 | 3.2% |
| Other values (4) | 171146 | 8.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2025292 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 561084 | |
| 0 | 304396 | |
| 2 | 206496 | 10.2% |
| . | 161645 | 8.0% |
| E | 161645 | 8.0% |
| + | 161645 | 8.0% |
| 7 | 92993 | 4.6% |
| 6 | 71859 | 3.5% |
| 4 | 67853 | 3.4% |
| 5 | 64530 | 3.2% |
| Other values (4) | 171146 | 8.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2025292 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 561084 | |
| 0 | 304396 | |
| 2 | 206496 | 10.2% |
| . | 161645 | 8.0% |
| E | 161645 | 8.0% |
| + | 161645 | 8.0% |
| 7 | 92993 | 4.6% |
| 6 | 71859 | 3.5% |
| 4 | 67853 | 3.4% |
| 5 | 64530 | 3.2% |
| Other values (4) | 171146 | 8.5% |
Permit Type
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.5222865 |
| Minimum | 1 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 8 |
| Q3 | 8 |
| 95-th percentile | 8 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.457526 |
|---|---|
| Coefficient of variation (CV) | 0.19376103 |
| Kurtosis | 6.036264 |
| Mean | 7.5222865 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.79896 |
| Sum | 1496258 |
| Variance | 2.124382 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 178852 | |
| 3 | 14664 | 7.4% |
| 4 | 2892 | 1.5% |
| 2 | 950 | 0.5% |
| 6 | 600 | 0.3% |
| 7 | 511 | 0.3% |
| 1 | 350 | 0.2% |
| 5 | 91 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 350 | 0.2% |
| 2 | 950 | 0.5% |
| 3 | 14664 | 7.4% |
| 4 | 2892 | 1.5% |
| 5 | 91 | < 0.1% |
| 6 | 600 | 0.3% |
| 7 | 511 | 0.3% |
| 8 | 178852 |
| Value | Count | Frequency (%) |
| 8 | 178852 | |
| 7 | 511 | 0.3% |
| 6 | 600 | 0.3% |
| 5 | 91 | < 0.1% |
| 4 | 2892 | 1.5% |
| 3 | 14664 | 7.4% |
| 2 | 950 | 0.5% |
| 1 | 350 | 0.2% |
Permit Type Definition
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.1 MiB |
| otc alterations permit | |
|---|---|
| additions alterations or repairs | 14663 |
| sign - erect | 2892 |
| new construction wood frame | 950 |
| demolitions | 600 |
| Other values (8) | 969 |
Length
| Max length | 35 |
|---|---|
| Median length | 22 |
| Mean length | 22.572978 |
| Min length | 11 |
Characters and Unicode
| Total characters | 4489991 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | otc alterations permit |
|---|---|
| 2nd row | otc alterations permit |
| 3rd row | otc alterations permit |
| 4th row | otc alterations permit |
| 5th row | otc alterations permit |
Common Values
| Value | Count | Frequency (%) |
| otc alterations permit | 178836 | |
| additions alterations or repairs | 14663 | 7.4% |
| sign - erect | 2892 | 1.5% |
| new construction wood frame | 950 | 0.5% |
| demolitions | 600 | 0.3% |
| wall or painted sign | 511 | 0.3% |
| new construction | 347 | 0.2% |
| grade or quarry or fill or excavate | 91 | < 0.1% |
| otc alterations permit | 8 | < 0.1% |
| otc alterations permit # | 8 | < 0.1% |
| Other values (3) | 4 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| alterations | 193516 | |
| otc | 178852 | |
| permit | 178852 | |
| or | 15448 | 2.5% |
| additions | 14664 | 2.4% |
| repairs | 14664 | 2.4% |
| sign | 3403 | 0.6% |
| 2902 | 0.5% | |
| erect | 2892 | 0.5% |
| construction | 1300 | 0.2% |
| Other values (10) | 5186 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 766094 | |
| i | 422865 | |
| r | 422559 | |
| a | 418696 | |
| 412789 | ||
| o | 408180 | |
| e | 396450 | |
| s | 228147 | 5.1% |
| n | 216594 | 4.8% |
| l | 195320 | 4.4% |
| Other values (14) | 602297 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4489991 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 766094 | |
| i | 422865 | |
| r | 422559 | |
| a | 418696 | |
| 412789 | ||
| o | 408180 | |
| e | 396450 | |
| s | 228147 | 5.1% |
| n | 216594 | 4.8% |
| l | 195320 | 4.4% |
| Other values (14) | 602297 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4489991 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 766094 | |
| i | 422865 | |
| r | 422559 | |
| a | 418696 | |
| 412789 | ||
| o | 408180 | |
| e | 396450 | |
| s | 228147 | 5.1% |
| n | 216594 | 4.8% |
| l | 195320 | 4.4% |
| Other values (14) | 602297 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4489991 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 766094 | |
| i | 422865 | |
| r | 422559 | |
| a | 418696 | |
| 412789 | ||
| o | 408180 | |
| e | 396450 | |
| s | 228147 | 5.1% |
| n | 216594 | 4.8% |
| l | 195320 | 4.4% |
| Other values (14) | 602297 |
| Distinct | 1291 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| Minimum | 2012-03-28 00:00:00 |
|---|---|
| Maximum | 2018-02-23 00:00:00 |
Block
Text
| Distinct | 4893 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.5 MiB |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 3.7171082 |
| Min length | 1 |
Characters and Unicode
| Total characters | 739370 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 122 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 3751 |
|---|---|
| 2nd row | 3556 |
| 3rd row | 655 |
| 4th row | 4267 |
| 5th row | 1518 |
| Value | Count | Frequency (%) |
| 3708 | 1195 | 0.6% |
| 3735 | 750 | 0.4% |
| 7331 | 680 | 0.3% |
| 289 | 640 | 0.3% |
| 3709 | 584 | 0.3% |
| 3717 | 578 | 0.3% |
| 3707 | 576 | 0.3% |
| 3721 | 567 | 0.3% |
| 3706 | 561 | 0.3% |
| 259 | 554 | 0.3% |
| Other values (4883) | 192225 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 97524 | |
| 1 | 96595 | |
| 2 | 85374 | |
| 5 | 80950 | |
| 6 | 77737 | |
| 7 | 73548 | |
| 0 | 60818 | |
| 4 | 60017 | |
| 8 | 50674 | |
| 9 | 48902 | |
| Other values (9) | 7231 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 739370 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 97524 | |
| 1 | 96595 | |
| 2 | 85374 | |
| 5 | 80950 | |
| 6 | 77737 | |
| 7 | 73548 | |
| 0 | 60818 | |
| 4 | 60017 | |
| 8 | 50674 | |
| 9 | 48902 | |
| Other values (9) | 7231 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 739370 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 97524 | |
| 1 | 96595 | |
| 2 | 85374 | |
| 5 | 80950 | |
| 6 | 77737 | |
| 7 | 73548 | |
| 0 | 60818 | |
| 4 | 60017 | |
| 8 | 50674 | |
| 9 | 48902 | |
| Other values (9) | 7231 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 739370 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 97524 | |
| 1 | 96595 | |
| 2 | 85374 | |
| 5 | 80950 | |
| 6 | 77737 | |
| 7 | 73548 | |
| 0 | 60818 | |
| 4 | 60017 | |
| 8 | 50674 | |
| 9 | 48902 | |
| Other values (9) | 7231 | 1.0% |
Lot
Text
| Distinct | 1050 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.2 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 2 |
| Mean length | 1.9519883 |
| Min length | 1 |
Characters and Unicode
| Total characters | 388270 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 178 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 172 |
|---|---|
| 2nd row | 6 |
| 3rd row | 61 |
| 4th row | 29 |
| 5th row | 37 |
| Value | Count | Frequency (%) |
| 1 | 10116 | 5.1% |
| 7 | 5317 | 2.7% |
| 2 | 5184 | 2.6% |
| 3 | 5042 | 2.5% |
| 6 | 4835 | 2.4% |
| 8 | 4773 | 2.4% |
| 9 | 4590 | 2.3% |
| 5 | 4549 | 2.3% |
| 4 | 4384 | 2.2% |
| 11 | 4238 | 2.1% |
| Other values (1040) | 145882 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 80415 | |
| 2 | 59437 | |
| 3 | 43028 | |
| 0 | 42471 | |
| 4 | 33218 | |
| 5 | 26863 | 6.9% |
| 6 | 25008 | 6.4% |
| 7 | 22210 | 5.7% |
| 8 | 20304 | 5.2% |
| 9 | 19441 | 5.0% |
| Other values (26) | 15875 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 388270 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 80415 | |
| 2 | 59437 | |
| 3 | 43028 | |
| 0 | 42471 | |
| 4 | 33218 | |
| 5 | 26863 | 6.9% |
| 6 | 25008 | 6.4% |
| 7 | 22210 | 5.7% |
| 8 | 20304 | 5.2% |
| 9 | 19441 | 5.0% |
| Other values (26) | 15875 | 4.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 388270 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 80415 | |
| 2 | 59437 | |
| 3 | 43028 | |
| 0 | 42471 | |
| 4 | 33218 | |
| 5 | 26863 | 6.9% |
| 6 | 25008 | 6.4% |
| 7 | 22210 | 5.7% |
| 8 | 20304 | 5.2% |
| 9 | 19441 | 5.0% |
| Other values (26) | 15875 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 388270 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 80415 | |
| 2 | 59437 | |
| 3 | 43028 | |
| 0 | 42471 | |
| 4 | 33218 | |
| 5 | 26863 | 6.9% |
| 6 | 25008 | 6.4% |
| 7 | 22210 | 5.7% |
| 8 | 20304 | 5.2% |
| 9 | 19441 | 5.0% |
| Other values (26) | 15875 | 4.1% |
Street Number
Real number (ℝ)
| Distinct | 5099 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1121.7155 |
| Minimum | 0 |
|---|---|
| Maximum | 8400 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 32 |
| Q1 | 235 |
| median | 710 |
| Q3 | 1700 |
| 95-th percentile | 3481 |
| Maximum | 8400 |
| Range | 8400 |
| Interquartile range (IQR) | 1465 |
Descriptive statistics
| Standard deviation | 1135.7985 |
|---|---|
| Coefficient of variation (CV) | 1.0125548 |
| Kurtosis | 2.1350541 |
| Mean | 1121.7155 |
| Median Absolute Deviation (MAD) | 580 |
| Skewness | 1.4269693 |
| Sum | 2.2312044 × 108 |
| Variance | 1290038.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2398 | 1.2% |
| 101 | 1153 | 0.6% |
| 100 | 1143 | 0.6% |
| 50 | 1103 | 0.6% |
| 201 | 1026 | 0.5% |
| 555 | 994 | 0.5% |
| 2 | 814 | 0.4% |
| 55 | 734 | 0.4% |
| 350 | 705 | 0.4% |
| 150 | 672 | 0.3% |
| Other values (5089) | 188168 |
| Value | Count | Frequency (%) |
| 0 | 4 | < 0.1% |
| 1 | 2398 | |
| 2 | 814 | 0.4% |
| 3 | 309 | 0.2% |
| 4 | 255 | 0.1% |
| 5 | 194 | 0.1% |
| 6 | 113 | 0.1% |
| 7 | 132 | 0.1% |
| 8 | 281 | 0.1% |
| 9 | 128 | 0.1% |
| Value | Count | Frequency (%) |
| 8400 | 3 | |
| 8331 | 1 | < 0.1% |
| 8325 | 5 | |
| 8320 | 1 | < 0.1% |
| 8300 | 1 | < 0.1% |
| 8245 | 1 | < 0.1% |
| 8231 | 1 | < 0.1% |
| 8228 | 1 | < 0.1% |
| 8222 | 7 | |
| 8219 | 1 | < 0.1% |
Street Number Suffix
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 196694 |
| Missing (%) | 98.9% |
| Memory size | 12.1 MiB |
| A | |
|---|---|
| B | |
| V | |
| C | 56 |
| E | 28 |
| Other values (13) | 112 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2216 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 1501 | 0.8% |
| B | 291 | 0.1% |
| V | 228 | 0.1% |
| C | 56 | < 0.1% |
| E | 28 | < 0.1% |
| F | 24 | < 0.1% |
| G | 12 | < 0.1% |
| D | 11 | < 0.1% |
| H | 11 | < 0.1% |
| K | 11 | < 0.1% |
| Other values (8) | 43 | < 0.1% |
| (Missing) | 196694 |
Length
| Value | Count | Frequency (%) |
| a | 1501 | |
| b | 291 | 13.1% |
| v | 228 | 10.3% |
| c | 56 | 2.5% |
| e | 28 | 1.3% |
| f | 24 | 1.1% |
| g | 12 | 0.5% |
| h | 11 | 0.5% |
| k | 11 | 0.5% |
| d | 11 | 0.5% |
| Other values (8) | 43 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1501 | |
| B | 291 | 13.1% |
| V | 228 | 10.3% |
| C | 56 | 2.5% |
| E | 28 | 1.3% |
| F | 24 | 1.1% |
| G | 12 | 0.5% |
| H | 11 | 0.5% |
| K | 11 | 0.5% |
| D | 11 | 0.5% |
| Other values (8) | 43 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2216 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 1501 | |
| B | 291 | 13.1% |
| V | 228 | 10.3% |
| C | 56 | 2.5% |
| E | 28 | 1.3% |
| F | 24 | 1.1% |
| G | 12 | 0.5% |
| H | 11 | 0.5% |
| K | 11 | 0.5% |
| D | 11 | 0.5% |
| Other values (8) | 43 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2216 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 1501 | |
| B | 291 | 13.1% |
| V | 228 | 10.3% |
| C | 56 | 2.5% |
| E | 28 | 1.3% |
| F | 24 | 1.1% |
| G | 12 | 0.5% |
| H | 11 | 0.5% |
| K | 11 | 0.5% |
| D | 11 | 0.5% |
| Other values (8) | 43 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2216 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 1501 | |
| B | 291 | 13.1% |
| V | 228 | 10.3% |
| C | 56 | 2.5% |
| E | 28 | 1.3% |
| F | 24 | 1.1% |
| G | 12 | 0.5% |
| H | 11 | 0.5% |
| K | 11 | 0.5% |
| D | 11 | 0.5% |
| Other values (8) | 43 | 1.9% |
Street Name
Text
| Distinct | 1714 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.0 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 22 |
| Mean length | 6.5098185 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1294868 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 117 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 03rD |
|---|---|
| 2nd row | gUeRrErO |
| 3rd row | pInE |
| 4th row | bRyAnT |
| 5th row | 26tH |
| Value | Count | Frequency (%) |
| market | 5443 | 2.6% |
| california | 4587 | 2.2% |
| mission | 4324 | 2.0% |
| montgomery | 2933 | 1.4% |
| geary | 1966 | 0.9% |
| 20th | 1859 | 0.9% |
| 03rd | 1819 | 0.9% |
| folsom | 1776 | 0.8% |
| van | 1698 | 0.8% |
| pine | 1678 | 0.8% |
| Other values (1705) | 184679 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 83888 | 6.5% |
| O | 63275 | 4.9% |
| e | 55861 | 4.3% |
| n | 55448 | 4.3% |
| r | 54146 | 4.2% |
| E | 54117 | 4.2% |
| t | 51943 | 4.0% |
| s | 49681 | 3.8% |
| R | 45151 | 3.5% |
| T | 42390 | 3.3% |
| Other values (55) | 738968 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1294868 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 83888 | 6.5% |
| O | 63275 | 4.9% |
| e | 55861 | 4.3% |
| n | 55448 | 4.3% |
| r | 54146 | 4.2% |
| E | 54117 | 4.2% |
| t | 51943 | 4.0% |
| s | 49681 | 3.8% |
| R | 45151 | 3.5% |
| T | 42390 | 3.3% |
| Other values (55) | 738968 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1294868 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 83888 | 6.5% |
| O | 63275 | 4.9% |
| e | 55861 | 4.3% |
| n | 55448 | 4.3% |
| r | 54146 | 4.2% |
| E | 54117 | 4.2% |
| t | 51943 | 4.0% |
| s | 49681 | 3.8% |
| R | 45151 | 3.5% |
| T | 42390 | 3.3% |
| Other values (55) | 738968 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1294868 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 83888 | 6.5% |
| O | 63275 | 4.9% |
| e | 55861 | 4.3% |
| n | 55448 | 4.3% |
| r | 54146 | 4.2% |
| E | 54117 | 4.2% |
| t | 51943 | 4.0% |
| s | 49681 | 3.8% |
| R | 45151 | 3.5% |
| T | 42390 | 3.3% |
| Other values (55) | 738968 |
Street Suffix
Categorical
IMBALANCE  MISSING 
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2768 |
| Missing (%) | 1.4% |
| Memory size | 11.2 MiB |
| St | |
|---|---|
| Av | |
| Bl | 3555 |
| Wy | 3540 |
| Dr | 3267 |
| Other values (16) | 4193 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 392284 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | St |
|---|---|
| 2nd row | St |
| 3rd row | St |
| 4th row | St |
| 5th row | Av |
Common Values
| Value | Count | Frequency (%) |
| St | 138365 | |
| Av | 43222 | 21.7% |
| Bl | 3555 | 1.8% |
| Wy | 3540 | 1.8% |
| Dr | 3267 | 1.6% |
| Tr | 1466 | 0.7% |
| Ct | 667 | 0.3% |
| Pl | 538 | 0.3% |
| Rd | 389 | 0.2% |
| Ln | 354 | 0.2% |
| Other values (11) | 779 | 0.4% |
| (Missing) | 2768 | 1.4% |
Length
| Value | Count | Frequency (%) |
| st | 138365 | |
| av | 43222 | 22.0% |
| bl | 3555 | 1.8% |
| wy | 3540 | 1.8% |
| dr | 3267 | 1.7% |
| tr | 1466 | 0.7% |
| ct | 667 | 0.3% |
| pl | 538 | 0.3% |
| rd | 389 | 0.2% |
| ln | 354 | 0.2% |
| Other values (11) | 779 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 139032 | |
| S | 138369 | |
| A | 43305 | 11.0% |
| v | 43222 | 11.0% |
| r | 4830 | 1.2% |
| l | 4177 | 1.1% |
| y | 3780 | 1.0% |
| B | 3555 | 0.9% |
| W | 3549 | 0.9% |
| D | 3267 | 0.8% |
| Other values (13) | 5198 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 392284 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 139032 | |
| S | 138369 | |
| A | 43305 | 11.0% |
| v | 43222 | 11.0% |
| r | 4830 | 1.2% |
| l | 4177 | 1.1% |
| y | 3780 | 1.0% |
| B | 3555 | 0.9% |
| W | 3549 | 0.9% |
| D | 3267 | 0.8% |
| Other values (13) | 5198 | 1.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 392284 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 139032 | |
| S | 138369 | |
| A | 43305 | 11.0% |
| v | 43222 | 11.0% |
| r | 4830 | 1.2% |
| l | 4177 | 1.1% |
| y | 3780 | 1.0% |
| B | 3555 | 0.9% |
| W | 3549 | 0.9% |
| D | 3267 | 0.8% |
| Other values (13) | 5198 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 392284 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 139032 | |
| S | 138369 | |
| A | 43305 | 11.0% |
| v | 43222 | 11.0% |
| r | 4830 | 1.2% |
| l | 4177 | 1.1% |
| y | 3780 | 1.0% |
| B | 3555 | 0.9% |
| W | 3549 | 0.9% |
| D | 3267 | 0.8% |
| Other values (13) | 5198 | 1.3% |
Unit
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 660 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 169430 |
| Missing (%) | 85.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 78.514518 |
| Minimum | 0 |
|---|---|
| Maximum | 6004 |
| Zeros | 21411 |
| Zeros (%) | 10.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 446.1 |
| Maximum | 6004 |
| Range | 6004 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 326.9761 |
|---|---|
| Coefficient of variation (CV) | 4.1645304 |
| Kurtosis | 92.15637 |
| Mean | 78.514518 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.1334162 |
| Sum | 2314608 |
| Variance | 106913.37 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 21411 | 10.8% |
| 1 | 1312 | 0.7% |
| 2 | 549 | 0.3% |
| 3 | 448 | 0.2% |
| 101 | 365 | 0.2% |
| 4 | 288 | 0.1% |
| 6 | 214 | 0.1% |
| 5 | 211 | 0.1% |
| 201 | 210 | 0.1% |
| 8 | 104 | 0.1% |
| Other values (650) | 4368 | 2.2% |
| (Missing) | 169430 |
| Value | Count | Frequency (%) |
| 0 | 21411 | |
| 1 | 1312 | 0.7% |
| 2 | 549 | 0.3% |
| 3 | 448 | 0.2% |
| 4 | 288 | 0.1% |
| 5 | 211 | 0.1% |
| 6 | 214 | 0.1% |
| 7 | 103 | 0.1% |
| 8 | 104 | 0.1% |
| 9 | 69 | < 0.1% |
| Value | Count | Frequency (%) |
| 6004 | 1 | < 0.1% |
| 6003 | 3 | |
| 5903 | 1 | < 0.1% |
| 5604 | 1 | < 0.1% |
| 5602 | 1 | < 0.1% |
| 5413 | 1 | < 0.1% |
| 5412 | 1 | < 0.1% |
| 5313 | 1 | < 0.1% |
| 5312 | 1 | < 0.1% |
| 5306 | 1 | < 0.1% |
Unit Suffix
Text
MISSING 
| Distinct | 163 |
|---|---|
| Distinct (%) | 8.3% |
| Missing | 196949 |
| Missing (%) | 99.0% |
| Memory size | 6.1 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 1 |
| Mean length | 2.6241713 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5146 |
|---|---|
| Distinct characters | 48 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 60 ? |
|---|---|
| Unique (%) | 3.1% |
Sample
| 1st row | FRONT UNIT |
|---|---|
| 2nd row | A |
| 3rd row | FRONT UNIT |
| 4th row | TENTATIVE |
| 5th row | REAR BLDG |
| Value | Count | Frequency (%) |
| a | 350 | |
| c | 229 | 10.7% |
| b | 193 | 9.0% |
| d | 137 | 6.4% |
| e | 93 | 4.3% |
| bldg | 93 | 4.3% |
| hoa | 85 | 4.0% |
| f | 78 | 3.6% |
| comml | 51 | 2.4% |
| front | 48 | 2.2% |
| Other values (136) | 792 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 551 | 10.7% |
| C | 409 | 7.9% |
| E | 331 | 6.4% |
| R | 311 | 6.0% |
| B | 309 | 6.0% |
| D | 295 | 5.7% |
| O | 264 | 5.1% |
| L | 261 | 5.1% |
| F | 208 | 4.0% |
| M | 192 | 3.7% |
| Other values (38) | 2015 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5146 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 551 | 10.7% |
| C | 409 | 7.9% |
| E | 331 | 6.4% |
| R | 311 | 6.0% |
| B | 309 | 6.0% |
| D | 295 | 5.7% |
| O | 264 | 5.1% |
| L | 261 | 5.1% |
| F | 208 | 4.0% |
| M | 192 | 3.7% |
| Other values (38) | 2015 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5146 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 551 | 10.7% |
| C | 409 | 7.9% |
| E | 331 | 6.4% |
| R | 311 | 6.0% |
| B | 309 | 6.0% |
| D | 295 | 5.7% |
| O | 264 | 5.1% |
| L | 261 | 5.1% |
| F | 208 | 4.0% |
| M | 192 | 3.7% |
| Other values (38) | 2015 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5146 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 551 | 10.7% |
| C | 409 | 7.9% |
| E | 331 | 6.4% |
| R | 311 | 6.0% |
| B | 309 | 6.0% |
| D | 295 | 5.7% |
| O | 264 | 5.1% |
| L | 261 | 5.1% |
| F | 208 | 4.0% |
| M | 192 | 3.7% |
| Other values (38) | 2015 |
Description
Text
| Distinct | 134272 |
|---|---|
| Distinct (%) | 67.6% |
| Missing | 290 |
| Missing (%) | 0.1% |
| Memory size | 30.0 MiB |
Length
| Max length | 300 |
|---|---|
| Median length | 243 |
| Mean length | 101.45318 |
| Min length | 1 |
Characters and Unicode
| Total characters | 20150631 |
|---|---|
| Distinct characters | 76 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 122032 ? |
|---|---|
| Unique (%) | 61.4% |
Sample
| 1st row | street space |
|---|---|
| 2nd row | remodel (e) bathroom, convert (e) bedrm into bed room and office, all work at ground floor, comply with complaint 200452633. items 3 & 4: existing furnaces to be used. |
| 3rd row | street space permit |
| 4th row | comply with nov 200009226 and 200346303 remoe e non permitted shed at the rear for unit 2607a. remodel bath, kitchen, new bedroom . unit 2607: remodel bathroom, kitchen, new bedroom, and bath. new lighting and fixtures for both unit |
| 5th row | replace 2 windows in bathroom not visible; no structural changes max u factor .40 |
| Value | Count | Frequency (%) |
| 94921 | 3.0% | |
| to | 93338 | 2.9% |
| and | 68894 | 2.2% |
| new | 61786 | 1.9% |
| of | 54700 | 1.7% |
| street | 44273 | 1.4% |
| space | 41100 | 1.3% |
| replace | 36545 | 1.1% |
| in | 36109 | 1.1% |
| for | 35061 | 1.1% |
| Other values (109535) | 2636742 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3042851 | ||
| e | 1735300 | 8.6% |
| o | 1280056 | 6.4% |
| r | 1277846 | 6.3% |
| t | 1208273 | 6.0% |
| n | 1153984 | 5.7% |
| a | 1149599 | 5.7% |
| i | 1122199 | 5.6% |
| s | 828425 | 4.1% |
| l | 785552 | 3.9% |
| Other values (66) | 6566546 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 20150631 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3042851 | ||
| e | 1735300 | 8.6% |
| o | 1280056 | 6.4% |
| r | 1277846 | 6.3% |
| t | 1208273 | 6.0% |
| n | 1153984 | 5.7% |
| a | 1149599 | 5.7% |
| i | 1122199 | 5.6% |
| s | 828425 | 4.1% |
| l | 785552 | 3.9% |
| Other values (66) | 6566546 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 20150631 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3042851 | ||
| e | 1735300 | 8.6% |
| o | 1280056 | 6.4% |
| r | 1277846 | 6.3% |
| t | 1208273 | 6.0% |
| n | 1153984 | 5.7% |
| a | 1149599 | 5.7% |
| i | 1122199 | 5.6% |
| s | 828425 | 4.1% |
| l | 785552 | 3.9% |
| Other values (66) | 6566546 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 20150631 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3042851 | ||
| e | 1735300 | 8.6% |
| o | 1280056 | 6.4% |
| r | 1277846 | 6.3% |
| t | 1208273 | 6.0% |
| n | 1153984 | 5.7% |
| a | 1149599 | 5.7% |
| i | 1122199 | 5.6% |
| s | 828425 | 4.1% |
| l | 785552 | 3.9% |
| Other values (66) | 6566546 |
Current Status
Categorical
IMBALANCE 
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.1 MiB |
| complete | |
|---|---|
| issued | |
| filed | |
| withdrawn | 1754 |
| cancelled | 1536 |
| Other values (9) | 2931 |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 6.9923282 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1390844 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | issued |
|---|---|
| 2nd row | complete |
| 3rd row | issued |
| 4th row | complete |
| 5th row | complete |
Common Values
| Value | Count | Frequency (%) |
| complete | 97081 | |
| issued | 83563 | |
| filed | 12045 | 6.1% |
| withdrawn | 1754 | 0.9% |
| cancelled | 1536 | 0.8% |
| expired | 1370 | 0.7% |
| approved | 733 | 0.4% |
| reinstated | 563 | 0.3% |
| suspend | 193 | 0.1% |
| revoked | 50 | < 0.1% |
| Other values (4) | 22 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| complete | 97081 | |
| issued | 83563 | |
| filed | 12045 | 6.1% |
| withdrawn | 1754 | 0.9% |
| cancelled | 1536 | 0.8% |
| expired | 1370 | 0.7% |
| approved | 733 | 0.4% |
| reinstated | 563 | 0.3% |
| suspend | 193 | 0.1% |
| revoked | 50 | < 0.1% |
| Other values (4) | 22 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 297758 | |
| s | 168077 | |
| l | 112218 | 8.1% |
| d | 101811 | 7.3% |
| c | 100187 | 7.2% |
| p | 100136 | 7.2% |
| t | 99963 | 7.2% |
| i | 99299 | 7.1% |
| o | 97868 | 7.0% |
| m | 97083 | 7.0% |
| Other values (10) | 116444 | 8.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1390844 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 297758 | |
| s | 168077 | |
| l | 112218 | 8.1% |
| d | 101811 | 7.3% |
| c | 100187 | 7.2% |
| p | 100136 | 7.2% |
| t | 99963 | 7.2% |
| i | 99299 | 7.1% |
| o | 97868 | 7.0% |
| m | 97083 | 7.0% |
| Other values (10) | 116444 | 8.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1390844 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 297758 | |
| s | 168077 | |
| l | 112218 | 8.1% |
| d | 101811 | 7.3% |
| c | 100187 | 7.2% |
| p | 100136 | 7.2% |
| t | 99963 | 7.2% |
| i | 99299 | 7.1% |
| o | 97868 | 7.0% |
| m | 97083 | 7.0% |
| Other values (10) | 116444 | 8.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1390844 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 297758 | |
| s | 168077 | |
| l | 112218 | 8.1% |
| d | 101811 | 7.3% |
| c | 100187 | 7.2% |
| p | 100136 | 7.2% |
| t | 99963 | 7.2% |
| i | 99299 | 7.1% |
| o | 97868 | 7.0% |
| m | 97083 | 7.0% |
| Other values (10) | 116444 | 8.4% |
| Distinct | 1307 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| Minimum | 2013-01-02 00:00:00 |
|---|---|
| Maximum | 2019-03-02 00:00:00 |
Filed Date
Date
| Distinct | 1288 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| Minimum | 2013-01-02 00:00:00 |
|---|---|
| Maximum | 2018-02-23 00:00:00 |
Issued Date
Date
MISSING 
| Distinct | 1289 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 14942 |
| Missing (%) | 7.5% |
| Memory size | 1.5 MiB |
| Minimum | 2013-01-02 00:00:00 |
|---|---|
| Maximum | 2018-02-23 00:00:00 |
Completed Date
Date
MISSING 
| Distinct | 1300 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 101715 |
| Missing (%) | 51.1% |
| Memory size | 1.5 MiB |
| Minimum | 2013-01-04 00:00:00 |
|---|---|
| Maximum | 2018-02-23 00:00:00 |
First Construction Document Date
Date
MISSING 
| Distinct | 1288 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 14948 |
| Missing (%) | 7.5% |
| Memory size | 1.5 MiB |
| Minimum | 2013-01-02 00:00:00 |
|---|---|
| Maximum | 2018-02-23 00:00:00 |
Structural Notification
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 191988 |
| Missing (%) | 96.5% |
| Memory size | 388.6 KiB |
| True | 6922 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 6922 | 3.5% |
| (Missing) | 191988 |
Number of Existing Stories
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 64 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 42788 |
| Missing (%) | 21.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.7057077 |
| Minimum | 0 |
|---|---|
| Maximum | 78 |
| Zeros | 442 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 26 |
| Maximum | 78 |
| Range | 78 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 8.6133098 |
|---|---|
| Coefficient of variation (CV) | 1.5095953 |
| Kurtosis | 11.309873 |
| Mean | 5.7057077 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.2978123 |
| Sum | 890786.5 |
| Variance | 74.189106 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 52770 | |
| 3 | 45741 | |
| 4 | 16055 | 8.1% |
| 1 | 8793 | 4.4% |
| 5 | 3767 | 1.9% |
| 6 | 3696 | 1.9% |
| 7 | 2359 | 1.2% |
| 8 | 1732 | 0.9% |
| 9 | 1264 | 0.6% |
| 10 | 1129 | 0.6% |
| Other values (54) | 18816 | 9.5% |
| (Missing) | 42788 |
| Value | Count | Frequency (%) |
| 0 | 442 | 0.2% |
| 1 | 8793 | 4.4% |
| 1.5 | 1 | < 0.1% |
| 2 | 52770 | |
| 2.5 | 2 | < 0.1% |
| 3 | 45741 | |
| 4 | 16055 | 8.1% |
| 5 | 3767 | 1.9% |
| 6 | 3696 | 1.9% |
| 7 | 2359 | 1.2% |
| Value | Count | Frequency (%) |
| 78 | 1 | < 0.1% |
| 63 | 99 | |
| 62 | 2 | < 0.1% |
| 61 | 24 | < 0.1% |
| 60 | 18 | < 0.1% |
| 58 | 93 | |
| 56 | 4 | < 0.1% |
| 55 | 14 | < 0.1% |
| 54 | 7 | < 0.1% |
| 53 | 12 | < 0.1% |
Number of Proposed Stories
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 64 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 42871 |
| Missing (%) | 21.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.7449644 |
| Minimum | 0 |
|---|---|
| Maximum | 78 |
| Zeros | 174 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 26 |
| Maximum | 78 |
| Range | 78 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 8.6131126 |
|---|---|
| Coefficient of variation (CV) | 1.4992456 |
| Kurtosis | 11.46678 |
| Mean | 5.7449644 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.3179006 |
| Sum | 896438.5 |
| Variance | 74.185708 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 50994 | |
| 3 | 46803 | |
| 4 | 17594 | 8.8% |
| 1 | 7893 | 4.0% |
| 5 | 4044 | 2.0% |
| 6 | 3792 | 1.9% |
| 7 | 2318 | 1.2% |
| 8 | 1703 | 0.9% |
| 9 | 1334 | 0.7% |
| 11 | 1120 | 0.6% |
| Other values (54) | 18444 | 9.3% |
| (Missing) | 42871 |
| Value | Count | Frequency (%) |
| 0 | 174 | 0.1% |
| 1 | 7893 | 4.0% |
| 1.5 | 1 | < 0.1% |
| 2 | 50994 | |
| 2.5 | 2 | < 0.1% |
| 3 | 46803 | |
| 4 | 17594 | 8.8% |
| 5 | 4044 | 2.0% |
| 6 | 3792 | 1.9% |
| 7 | 2318 | 1.2% |
| Value | Count | Frequency (%) |
| 78 | 1 | < 0.1% |
| 63 | 105 | |
| 62 | 4 | < 0.1% |
| 61 | 24 | < 0.1% |
| 60 | 19 | < 0.1% |
| 58 | 90 | |
| 56 | 11 | < 0.1% |
| 55 | 23 | < 0.1% |
| 54 | 14 | < 0.1% |
| 53 | 12 | < 0.1% |
Voluntary Soft-Story Retrofit
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 198875 |
| Missing (%) | > 99.9% |
| Memory size | 388.6 KiB |
| True | 35 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 35 | < 0.1% |
| (Missing) | 198875 |
Fire Only Permit
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 180082 |
| Missing (%) | 90.5% |
| Memory size | 388.6 KiB |
| True | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 18828 | 9.5% |
| (Missing) | 180082 |
MISSING 
| Distinct | 2232 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 51884 |
| Missing (%) | 26.1% |
| Memory size | 1.5 MiB |
| Minimum | 2013-07-15 00:00:00 |
|---|---|
| Maximum | 2024-02-21 00:00:00 |
Estimated Cost
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED 
| Distinct | 11395 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 38068 |
| Missing (%) | 19.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 169009.86 |
| Minimum | 1 |
|---|---|
| Maximum | 5.3795865 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3300 |
| median | 11000 |
| Q3 | 35000 |
| 95-th percentile | 275000 |
| Maximum | 5.3795865 × 108 |
| Range | 5.3795864 × 108 |
| Interquartile range (IQR) | 31700 |
Descriptive statistics
| Standard deviation | 3630376.9 |
|---|---|
| Coefficient of variation (CV) | 21.480267 |
| Kurtosis | 8911.3386 |
| Mean | 169009.86 |
| Median Absolute Deviation (MAD) | 10000 |
| Skewness | 80.264355 |
| Sum | 2.7183884 × 1010 |
| Variance | 1.3179636 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 17014 | 8.6% |
| 10000 | 6695 | 3.4% |
| 5000 | 6437 | 3.2% |
| 20000 | 5702 | 2.9% |
| 15000 | 4779 | 2.4% |
| 30000 | 3939 | 2.0% |
| 25000 | 3599 | 1.8% |
| 3000 | 3569 | 1.8% |
| 50000 | 3345 | 1.7% |
| 2000 | 3203 | 1.6% |
| Other values (11385) | 102560 | |
| (Missing) | 38068 | 19.1% |
| Value | Count | Frequency (%) |
| 1 | 17014 | |
| 2 | 1 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 3 | < 0.1% |
| 10 | 11 | < 0.1% |
| 20 | 5 | < 0.1% |
| 25 | 7 | < 0.1% |
| 30 | 3 | < 0.1% |
| 35 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 537958646 | 1 | |
| 520000000 | 1 | |
| 400000000 | 2 | |
| 340000000 | 1 | |
| 272000000 | 1 | |
| 270000000 | 1 | |
| 239000000 | 1 | |
| 210000000 | 1 | |
| 175000000 | 1 | |
| 167000000 | 2 |
Revised Cost
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED  ZEROS 
| Distinct | 12629 |
|---|---|
| Distinct (%) | 6.5% |
| Missing | 6066 |
| Missing (%) | 3.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 132901.75 |
| Minimum | 0 |
|---|---|
| Maximum | 7.805 × 108 |
| Zeros | 8514 |
| Zeros (%) | 4.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 7000 |
| Q3 | 28715 |
| 95-th percentile | 227340 |
| Maximum | 7.805 × 108 |
| Range | 7.805 × 108 |
| Interquartile range (IQR) | 28714 |
Descriptive statistics
| Standard deviation | 3584878.7 |
|---|---|
| Coefficient of variation (CV) | 26.973901 |
| Kurtosis | 17049.467 |
| Mean | 132901.75 |
| Median Absolute Deviation (MAD) | 6999 |
| Skewness | 108.7016 |
| Sum | 2.5629306 × 1010 |
| Variance | 1.2851355 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 47229 | |
| 0 | 8514 | 4.3% |
| 10000 | 5474 | 2.8% |
| 5000 | 5453 | 2.7% |
| 20000 | 4696 | 2.4% |
| 15000 | 4001 | 2.0% |
| 30000 | 3291 | 1.7% |
| 25000 | 3135 | 1.6% |
| 3000 | 3067 | 1.5% |
| 2000 | 2955 | 1.5% |
| Other values (12619) | 105029 | |
| (Missing) | 6066 | 3.0% |
| Value | Count | Frequency (%) |
| 0 | 8514 | 4.3% |
| 0.01 | 1 | < 0.1% |
| 1 | 47229 | |
| 1.2 | 1 | < 0.1% |
| 2 | 4 | < 0.1% |
| 5 | 3 | < 0.1% |
| 10 | 11 | < 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 14 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 780500000 | 1 | < 0.1% |
| 520000000 | 1 | < 0.1% |
| 400000000 | 2 | |
| 336200000 | 1 | < 0.1% |
| 270000000 | 1 | < 0.1% |
| 266061486 | 1 | < 0.1% |
| 239000000 | 1 | < 0.1% |
| 210000000 | 1 | < 0.1% |
| 207680000 | 1 | < 0.1% |
| 200000000 | 4 |
Existing Use
Text
MISSING 
| Distinct | 93 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 41117 |
| Missing (%) | 20.7% |
| Memory size | 11.8 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 19 |
| Mean length | 13.170286 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2078179 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | apartments |
|---|---|
| 2nd row | apartments |
| 3rd row | 2 family dwelling |
| 4th row | 2 family dwelling |
| 5th row | 1 family dwelling |
| Value | Count | Frequency (%) |
| family | 67756 | |
| dwelling | 67756 | |
| 1 | 46768 | |
| apartments | 40800 | |
| office | 24617 | 7.8% |
| 2 | 20988 | 6.6% |
| sales | 7032 | 2.2% |
| retail | 6910 | 2.2% |
| hndlng | 4886 | 1.5% |
| food/beverage | 4886 | 1.5% |
| Other values (144) | 24040 | 7.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 235150 | 11.3% |
| a | 181738 | 8.7% |
| i | 179803 | 8.7% |
| e | 177532 | 8.5% |
| 158646 | 7.6% | |
| n | 129792 | 6.2% |
| f | 123927 | 6.0% |
| m | 113200 | 5.4% |
| t | 108688 | 5.2% |
| d | 81432 | 3.9% |
| Other values (29) | 588271 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2078179 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 235150 | 11.3% |
| a | 181738 | 8.7% |
| i | 179803 | 8.7% |
| e | 177532 | 8.5% |
| 158646 | 7.6% | |
| n | 129792 | 6.2% |
| f | 123927 | 6.0% |
| m | 113200 | 5.4% |
| t | 108688 | 5.2% |
| d | 81432 | 3.9% |
| Other values (29) | 588271 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2078179 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 235150 | 11.3% |
| a | 181738 | 8.7% |
| i | 179803 | 8.7% |
| e | 177532 | 8.5% |
| 158646 | 7.6% | |
| n | 129792 | 6.2% |
| f | 123927 | 6.0% |
| m | 113200 | 5.4% |
| t | 108688 | 5.2% |
| d | 81432 | 3.9% |
| Other values (29) | 588271 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2078179 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 235150 | 11.3% |
| a | 181738 | 8.7% |
| i | 179803 | 8.7% |
| e | 177532 | 8.5% |
| 158646 | 7.6% | |
| n | 129792 | 6.2% |
| f | 123927 | 6.0% |
| m | 113200 | 5.4% |
| t | 108688 | 5.2% |
| d | 81432 | 3.9% |
| Other values (29) | 588271 |
Existing Units
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 348 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 51543 |
| Missing (%) | 25.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.666006 |
| Minimum | 0 |
|---|---|
| Maximum | 1907 |
| Zeros | 29135 |
| Zeros (%) | 14.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 4 |
| 95-th percentile | 64 |
| Maximum | 1907 |
| Range | 1907 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 74.47512 |
|---|---|
| Coefficient of variation (CV) | 4.7539316 |
| Kurtosis | 238.3122 |
| Mean | 15.666006 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 12.867436 |
| Sum | 2308652.3 |
| Variance | 5546.5435 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 47347 | |
| 0 | 29135 | |
| 2 | 21805 | |
| 3 | 8616 | 4.3% |
| 6 | 6066 | 3.0% |
| 4 | 5364 | 2.7% |
| 12 | 2535 | 1.3% |
| 5 | 2347 | 1.2% |
| 8 | 1728 | 0.9% |
| 9 | 1188 | 0.6% |
| Other values (338) | 21236 | |
| (Missing) | 51543 |
| Value | Count | Frequency (%) |
| 0 | 29135 | |
| 0.3 | 1 | < 0.1% |
| 1 | 47347 | |
| 2 | 21805 | |
| 3 | 8616 | 4.3% |
| 4 | 5364 | 2.7% |
| 5 | 2347 | 1.2% |
| 6 | 6066 | 3.0% |
| 7 | 1172 | 0.6% |
| 8 | 1728 | 0.9% |
| Value | Count | Frequency (%) |
| 1907 | 44 | |
| 1732 | 8 | < 0.1% |
| 1500 | 51 | |
| 1499 | 1 | < 0.1% |
| 1186 | 51 | |
| 1010 | 2 | < 0.1% |
| 1005 | 21 | |
| 1004 | 2 | < 0.1% |
| 1000 | 1 | < 0.1% |
| 948 | 1 | < 0.1% |
Proposed Use
Text
MISSING 
| Distinct | 94 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 42441 |
| Missing (%) | 21.3% |
| Memory size | 11.8 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 19 |
| Mean length | 13.208827 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2066772 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | apartments |
|---|---|
| 2nd row | apartments |
| 3rd row | 2 family dwelling |
| 4th row | 2 family dwelling |
| 5th row | 1 family dwelling |
| Value | Count | Frequency (%) |
| family | 68410 | |
| dwelling | 68410 | |
| 1 | 46348 | |
| apartments | 43035 | |
| office | 23963 | 7.7% |
| 2 | 22062 | 7.0% |
| sales | 5193 | 1.7% |
| retail | 5079 | 1.6% |
| food/beverage | 5053 | 1.6% |
| hndlng | 5053 | 1.6% |
| Other values (146) | 20614 | 6.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 232125 | 11.2% |
| a | 179985 | 8.7% |
| i | 177628 | 8.6% |
| e | 175966 | 8.5% |
| 156751 | 7.6% | |
| n | 130398 | 6.3% |
| f | 123053 | 6.0% |
| m | 116197 | 5.6% |
| t | 107434 | 5.2% |
| d | 82574 | 4.0% |
| Other values (29) | 584661 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2066772 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 232125 | 11.2% |
| a | 179985 | 8.7% |
| i | 177628 | 8.6% |
| e | 175966 | 8.5% |
| 156751 | 7.6% | |
| n | 130398 | 6.3% |
| f | 123053 | 6.0% |
| m | 116197 | 5.6% |
| t | 107434 | 5.2% |
| d | 82574 | 4.0% |
| Other values (29) | 584661 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2066772 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 232125 | 11.2% |
| a | 179985 | 8.7% |
| i | 177628 | 8.6% |
| e | 175966 | 8.5% |
| 156751 | 7.6% | |
| n | 130398 | 6.3% |
| f | 123053 | 6.0% |
| m | 116197 | 5.6% |
| t | 107434 | 5.2% |
| d | 82574 | 4.0% |
| Other values (29) | 584661 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2066772 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 232125 | 11.2% |
| a | 179985 | 8.7% |
| i | 177628 | 8.6% |
| e | 175966 | 8.5% |
| 156751 | 7.6% | |
| n | 130398 | 6.3% |
| f | 123053 | 6.0% |
| m | 116197 | 5.6% |
| t | 107434 | 5.2% |
| d | 82574 | 4.0% |
| Other values (29) | 584661 |
Proposed Units
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 368 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 50915 |
| Missing (%) | 25.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.510882 |
| Minimum | 0 |
|---|---|
| Maximum | 1911 |
| Zeros | 26885 |
| Zeros (%) | 13.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 70 |
| Maximum | 1911 |
| Range | 1911 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 75.218997 |
|---|---|
| Coefficient of variation (CV) | 4.5557225 |
| Kurtosis | 223.71262 |
| Mean | 16.510882 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 12.330487 |
| Sum | 2443528 |
| Variance | 5657.8975 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 46914 | |
| 0 | 26885 | |
| 2 | 22892 | |
| 3 | 9347 | 4.7% |
| 6 | 5872 | 3.0% |
| 4 | 5504 | 2.8% |
| 12 | 2474 | 1.2% |
| 5 | 2400 | 1.2% |
| 8 | 1800 | 0.9% |
| 7 | 1336 | 0.7% |
| Other values (358) | 22571 | |
| (Missing) | 50915 |
| Value | Count | Frequency (%) |
| 0 | 26885 | |
| 1 | 46914 | |
| 2 | 22892 | |
| 3 | 9347 | 4.7% |
| 4 | 5504 | 2.8% |
| 5 | 2400 | 1.2% |
| 6 | 5872 | 3.0% |
| 7 | 1336 | 0.7% |
| 8 | 1800 | 0.9% |
| 9 | 1270 | 0.6% |
| Value | Count | Frequency (%) |
| 1911 | 1 | < 0.1% |
| 1907 | 43 | |
| 1732 | 8 | < 0.1% |
| 1500 | 48 | |
| 1499 | 1 | < 0.1% |
| 1199 | 1 | < 0.1% |
| 1186 | 47 | |
| 1014 | 4 | < 0.1% |
| 1010 | 2 | < 0.1% |
| 1005 | 17 | < 0.1% |
Plansets
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED  ZEROS 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 37311 |
| Missing (%) | 18.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.274649 |
| Minimum | 0 |
|---|---|
| Maximum | 9000 |
| Zeros | 63247 |
| Zeros (%) | 31.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 9000 |
| Range | 9000 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 22.406792 |
|---|---|
| Coefficient of variation (CV) | 17.578794 |
| Kurtosis | 160982 |
| Mean | 1.274649 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 400.84207 |
| Sum | 205982 |
| Variance | 502.06432 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 98093 | |
| 0 | 63247 | |
| 3 | 250 | 0.1% |
| 4 | 3 | < 0.1% |
| 6 | 2 | < 0.1% |
| 1 | 2 | < 0.1% |
| 20 | 1 | < 0.1% |
| 9000 | 1 | < 0.1% |
| (Missing) | 37311 | 18.8% |
| Value | Count | Frequency (%) |
| 0 | 63247 | |
| 1 | 2 | < 0.1% |
| 2 | 98093 | |
| 3 | 250 | 0.1% |
| 4 | 3 | < 0.1% |
| 6 | 2 | < 0.1% |
| 20 | 1 | < 0.1% |
| 9000 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9000 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 6 | 2 | < 0.1% |
| 4 | 3 | < 0.1% |
| 3 | 250 | 0.1% |
| 2 | 98093 | |
| 1 | 2 | < 0.1% |
| 0 | 63247 |
TIDF Compliance
Text
MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 198908 |
| Missing (%) | > 99.9% |
| Memory size | 6.1 MiB |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | P |
|---|---|
| 2nd row | Y |
| Value | Count | Frequency (%) |
| p | 1 | |
| y | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 1 | |
| Y | 1 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 1 | |
| Y | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 1 | |
| Y | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 1 | |
| Y | 1 |
Existing Construction Type
Real number (ℝ)
HIGH CORRELATION  MISSING  SKEWED 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 43369 |
| Missing (%) | 21.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.7156312 |
| Minimum | -99999 |
|---|---|
| Maximum | 99999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -99999 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 99999 |
| Range | 199998 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 566.96662 |
|---|---|
| Coefficient of variation (CV) | 120.23133 |
| Kurtosis | 31105.634 |
| Mean | 4.7156312 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 35.250938 |
| Sum | 733474 |
| Variance | 321451.15 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 113350 | |
| 1 | 28073 | 14.1% |
| 3 | 9664 | 4.9% |
| 2 | 4068 | 2.0% |
| 4 | 381 | 0.2% |
| 99999 | 3 | < 0.1% |
| -99999 | 2 | < 0.1% |
| (Missing) | 43369 | 21.8% |
| Value | Count | Frequency (%) |
| -99999 | 2 | < 0.1% |
| 1 | 28073 | 14.1% |
| 2 | 4068 | 2.0% |
| 3 | 9664 | 4.9% |
| 4 | 381 | 0.2% |
| 5 | 113350 | |
| 99999 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99999 | 3 | < 0.1% |
| 5 | 113350 | |
| 4 | 381 | 0.2% |
| 3 | 9664 | 4.9% |
| 2 | 4068 | 2.0% |
| 1 | 28073 | 14.1% |
| -99999 | 2 | < 0.1% |
Existing Construction Type Description
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 43370 |
| Missing (%) | 21.8% |
| Memory size | 13.1 MiB |
| wood frame (5) | |
|---|---|
| constr type 1 | |
| constr type 3 | 9663 |
| constr type 2 | 4068 |
| constr type 4 | 381 |
| Other values (3) | 6 |
Length
| Max length | 16 |
|---|---|
| Median length | 14 |
| Mean length | 13.728854 |
| Min length | 13 |
Characters and Unicode
| Total characters | 2135386 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | wood frame (5) |
|---|---|
| 2nd row | wood frame (5) |
| 3rd row | wood frame (5) |
| 4th row | wood frame (5) |
| 5th row | wood frame (5) |
Common Values
| Value | Count | Frequency (%) |
| wood frame (5) | 113350 | |
| constr type 1 | 28072 | 14.1% |
| constr type 3 | 9663 | 4.9% |
| constr type 2 | 4068 | 2.0% |
| constr type 4 | 381 | 0.2% |
| wood frame (5) | 4 | < 0.1% |
| constr type 1 | 1 | < 0.1% |
| constr type 3 | 1 | < 0.1% |
| (Missing) | 43370 | 21.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| wood | 113354 | |
| frame | 113354 | |
| 5 | 113354 | |
| constr | 42186 | 9.0% |
| type | 42186 | 9.0% |
| 1 | 28073 | 6.0% |
| 3 | 9664 | 2.1% |
| 2 | 4068 | 0.9% |
| 4 | 381 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 311092 | ||
| o | 268894 | |
| e | 155540 | 7.3% |
| r | 155540 | 7.3% |
| w | 113354 | 5.3% |
| 5 | 113354 | 5.3% |
| ( | 113354 | 5.3% |
| ) | 113354 | 5.3% |
| m | 113354 | 5.3% |
| a | 113354 | 5.3% |
| Other values (12) | 564196 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2135386 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 311092 | ||
| o | 268894 | |
| e | 155540 | 7.3% |
| r | 155540 | 7.3% |
| w | 113354 | 5.3% |
| 5 | 113354 | 5.3% |
| ( | 113354 | 5.3% |
| ) | 113354 | 5.3% |
| m | 113354 | 5.3% |
| a | 113354 | 5.3% |
| Other values (12) | 564196 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2135386 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 311092 | ||
| o | 268894 | |
| e | 155540 | 7.3% |
| r | 155540 | 7.3% |
| w | 113354 | 5.3% |
| 5 | 113354 | 5.3% |
| ( | 113354 | 5.3% |
| ) | 113354 | 5.3% |
| m | 113354 | 5.3% |
| a | 113354 | 5.3% |
| Other values (12) | 564196 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2135386 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 311092 | ||
| o | 268894 | |
| e | 155540 | 7.3% |
| r | 155540 | 7.3% |
| w | 113354 | 5.3% |
| 5 | 113354 | 5.3% |
| ( | 113354 | 5.3% |
| ) | 113354 | 5.3% |
| m | 113354 | 5.3% |
| a | 113354 | 5.3% |
| Other values (12) | 564196 |
Proposed Construction Type
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 43165 |
| Missing (%) | 21.7% |
| Memory size | 11.5 MiB |
| 5.0 | |
|---|---|
| 1.0 | |
| 3.0 | 9361 |
| 2.0 | 3778 |
| 4.0 | 377 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 467235 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 5.0 |
|---|---|
| 2nd row | 5.0 |
| 3rd row | 5.0 |
| 4th row | 5.0 |
| 5th row | 5.0 |
Common Values
| Value | Count | Frequency (%) |
| 5.0 | 114386 | |
| 1.0 | 27843 | 14.0% |
| 3.0 | 9361 | 4.7% |
| 2.0 | 3778 | 1.9% |
| 4.0 | 377 | 0.2% |
| (Missing) | 43165 | 21.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 5.0 | 114386 | |
| 1.0 | 27843 | 17.9% |
| 3.0 | 9361 | 6.0% |
| 2.0 | 3778 | 2.4% |
| 4.0 | 377 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 155745 | |
| 0 | 155745 | |
| 5 | 114386 | |
| 1 | 27843 | 6.0% |
| 3 | 9361 | 2.0% |
| 2 | 3778 | 0.8% |
| 4 | 377 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 467235 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 155745 | |
| 0 | 155745 | |
| 5 | 114386 | |
| 1 | 27843 | 6.0% |
| 3 | 9361 | 2.0% |
| 2 | 3778 | 0.8% |
| 4 | 377 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 467235 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 155745 | |
| 0 | 155745 | |
| 5 | 114386 | |
| 1 | 27843 | 6.0% |
| 3 | 9361 | 2.0% |
| 2 | 3778 | 0.8% |
| 4 | 377 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 467235 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 155745 | |
| 0 | 155745 | |
| 5 | 114386 | |
| 1 | 27843 | 6.0% |
| 3 | 9361 | 2.0% |
| 2 | 3778 | 0.8% |
| 4 | 377 | 0.1% |
Proposed Construction Type Description
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 43165 |
| Missing (%) | 21.7% |
| Memory size | 13.1 MiB |
| wood frame (5) | |
|---|---|
| constr type 1 | |
| constr type 3 | 9361 |
| constr type 2 | 3778 |
| constr type 4 | 377 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 13.734444 |
| Min length | 13 |
Characters and Unicode
| Total characters | 2139071 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | wood frame (5) |
|---|---|
| 2nd row | wood frame (5) |
| 3rd row | wood frame (5) |
| 4th row | wood frame (5) |
| 5th row | wood frame (5) |
Common Values
| Value | Count | Frequency (%) |
| wood frame (5) | 114386 | |
| constr type 1 | 27843 | 14.0% |
| constr type 3 | 9361 | 4.7% |
| constr type 2 | 3778 | 1.9% |
| constr type 4 | 377 | 0.2% |
| (Missing) | 43165 | 21.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| wood | 114386 | |
| frame | 114386 | |
| 5 | 114386 | |
| constr | 41359 | 8.9% |
| type | 41359 | 8.9% |
| 1 | 27843 | 6.0% |
| 3 | 9361 | 2.0% |
| 2 | 3778 | 0.8% |
| 4 | 377 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 311490 | ||
| o | 270131 | |
| e | 155745 | 7.3% |
| r | 155745 | 7.3% |
| w | 114386 | 5.3% |
| 5 | 114386 | 5.3% |
| ( | 114386 | 5.3% |
| ) | 114386 | 5.3% |
| m | 114386 | 5.3% |
| a | 114386 | 5.3% |
| Other values (12) | 559644 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2139071 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 311490 | ||
| o | 270131 | |
| e | 155745 | 7.3% |
| r | 155745 | 7.3% |
| w | 114386 | 5.3% |
| 5 | 114386 | 5.3% |
| ( | 114386 | 5.3% |
| ) | 114386 | 5.3% |
| m | 114386 | 5.3% |
| a | 114386 | 5.3% |
| Other values (12) | 559644 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2139071 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 311490 | ||
| o | 270131 | |
| e | 155745 | 7.3% |
| r | 155745 | 7.3% |
| w | 114386 | 5.3% |
| 5 | 114386 | 5.3% |
| ( | 114386 | 5.3% |
| ) | 114386 | 5.3% |
| m | 114386 | 5.3% |
| a | 114386 | 5.3% |
| Other values (12) | 559644 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2139071 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 311490 | ||
| o | 270131 | |
| e | 155745 | 7.3% |
| r | 155745 | 7.3% |
| w | 114386 | 5.3% |
| 5 | 114386 | 5.3% |
| ( | 114386 | 5.3% |
| ) | 114386 | 5.3% |
| m | 114386 | 5.3% |
| a | 114386 | 5.3% |
| Other values (12) | 559644 |
Site Permit
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 193550 |
| Missing (%) | 97.3% |
| Memory size | 388.6 KiB |
| True | 5360 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 5360 | 2.7% |
| (Missing) | 193550 |
Supervisor District
Categorical
HIGH CORRELATION 
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1719 |
| Missing (%) | 0.9% |
| Memory size | 11.0 MiB |
| 3 | |
|---|---|
| 8 | |
| 2 | |
| 6 | |
| 5 | |
| Other values (9) |
Length
| Max length | 6 |
|---|---|
| Median length | 1 |
| Mean length | 1.0968959 |
| Min length | 1 |
Characters and Unicode
| Total characters | 216298 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 8 |
|---|---|
| 2nd row | 2 |
| 3rd row | 9 |
| 4th row | 1 |
| 5th row | 9 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 28649 | |
| 8 | 26761 | |
| 2 | 25484 | |
| 6 | 24797 | |
| 5 | 19045 | |
| 9 | 16362 | |
| 7 | 14365 | |
| 1 | 13039 | |
| 10 | 12153 | |
| 4 | 9592 | 4.8% |
| Other values (4) | 6944 | 3.5% |
Length
| Value | Count | Frequency (%) |
| 3 | 28649 | |
| 8 | 26761 | |
| 2 | 25484 | |
| 6 | 24797 | |
| 5 | 19045 | |
| 9 | 16362 | |
| 7 | 14365 | |
| 1 | 13039 | |
| 10 | 12153 | |
| 4 | 9592 | 4.9% |
| Other values (4) | 6944 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 39074 | |
| 3 | 28649 | |
| 8 | 26761 | |
| 2 | 25484 | |
| 6 | 24797 | |
| 5 | 19045 | |
| 9 | 16362 | |
| 7 | 14365 | 6.6% |
| 0 | 12153 | 5.6% |
| 4 | 9592 | 4.4% |
| Other values (10) | 16 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 216298 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 39074 | |
| 3 | 28649 | |
| 8 | 26761 | |
| 2 | 25484 | |
| 6 | 24797 | |
| 5 | 19045 | |
| 9 | 16362 | |
| 7 | 14365 | 6.6% |
| 0 | 12153 | 5.6% |
| 4 | 9592 | 4.4% |
| Other values (10) | 16 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 216298 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 39074 | |
| 3 | 28649 | |
| 8 | 26761 | |
| 2 | 25484 | |
| 6 | 24797 | |
| 5 | 19045 | |
| 9 | 16362 | |
| 7 | 14365 | 6.6% |
| 0 | 12153 | 5.6% |
| 4 | 9592 | 4.4% |
| Other values (10) | 16 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 216298 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 39074 | |
| 3 | 28649 | |
| 8 | 26761 | |
| 2 | 25484 | |
| 6 | 24797 | |
| 5 | 19045 | |
| 9 | 16362 | |
| 7 | 14365 | 6.6% |
| 0 | 12153 | 5.6% |
| 4 | 9592 | 4.4% |
| Other values (10) | 16 | < 0.1% |
Neighborhoods - Analysis Boundaries
Categorical
HIGH CORRELATION 
| Distinct | 41 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1725 |
| Missing (%) | 0.9% |
| Memory size | 13.6 MiB |
| Financial District/South Beach | |
|---|---|
| Mission | |
| Sunset/Parkside | 10207 |
| West of Twin Peaks | 8740 |
| Castro/Upper Market | 8527 |
| Other values (36) |
Length
| Max length | 30 |
|---|---|
| Median length | 18 |
| Mean length | 14.780977 |
| Min length | 6 |
Characters and Unicode
| Total characters | 2914587 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mission |
|---|---|
| 2nd row | Pacific Heights |
| 3rd row | Mission |
| 4th row | Outer Richmond |
| 5th row | Bernal Heights |
Common Values
| Value | Count | Frequency (%) |
| Financial District/South Beach | 21816 | 11.0% |
| Mission | 14682 | 7.4% |
| Sunset/Parkside | 10207 | 5.1% |
| West of Twin Peaks | 8740 | 4.4% |
| Castro/Upper Market | 8527 | 4.3% |
| Pacific Heights | 8508 | 4.3% |
| Marina | 8244 | 4.1% |
| Outer Richmond | 7855 | 3.9% |
| Noe Valley | 7844 | 3.9% |
| South of Market | 7573 | 3.8% |
| Other values (31) | 93189 |
Length
| Value | Count | Frequency (%) |
| beach | 25870 | 6.5% |
| financial | 21816 | 5.5% |
| district/south | 21816 | 5.5% |
| mission | 19211 | 4.9% |
| heights | 18661 | 4.7% |
| of | 16313 | 4.1% |
| market | 16100 | 4.1% |
| hill | 15798 | 4.0% |
| valley | 14233 | 3.6% |
| richmond | 12313 | 3.1% |
| Other values (46) | 212950 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 281035 | 9.6% |
| e | 234500 | 8.0% |
| a | 203693 | 7.0% |
| n | 198634 | 6.8% |
| 197896 | 6.8% | |
| t | 194569 | 6.7% |
| s | 176846 | 6.1% |
| o | 150144 | 5.2% |
| r | 148187 | 5.1% |
| c | 109199 | 3.7% |
| Other values (36) | 1019884 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2914587 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 281035 | 9.6% |
| e | 234500 | 8.0% |
| a | 203693 | 7.0% |
| n | 198634 | 6.8% |
| 197896 | 6.8% | |
| t | 194569 | 6.7% |
| s | 176846 | 6.1% |
| o | 150144 | 5.2% |
| r | 148187 | 5.1% |
| c | 109199 | 3.7% |
| Other values (36) | 1019884 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2914587 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 281035 | 9.6% |
| e | 234500 | 8.0% |
| a | 203693 | 7.0% |
| n | 198634 | 6.8% |
| 197896 | 6.8% | |
| t | 194569 | 6.7% |
| s | 176846 | 6.1% |
| o | 150144 | 5.2% |
| r | 148187 | 5.1% |
| c | 109199 | 3.7% |
| Other values (36) | 1019884 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2914587 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 281035 | 9.6% |
| e | 234500 | 8.0% |
| a | 203693 | 7.0% |
| n | 198634 | 6.8% |
| 197896 | 6.8% | |
| t | 194569 | 6.7% |
| s | 176846 | 6.1% |
| o | 150144 | 5.2% |
| r | 148187 | 5.1% |
| c | 109199 | 3.7% |
| Other values (36) | 1019884 |
Zipcode
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1716 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94115.501 |
| Minimum | 94102 |
|---|---|
| Maximum | 94158 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 94102 |
|---|---|
| 5-th percentile | 94103 |
| Q1 | 94109 |
| median | 94114 |
| Q3 | 94122 |
| 95-th percentile | 94133 |
| Maximum | 94158 |
| Range | 56 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 9.2701045 |
|---|---|
| Coefficient of variation (CV) | 9.8497107 × 10-5 |
| Kurtosis | 1.2263383 |
| Mean | 94115.501 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.85171252 |
| Sum | 1.8559012 × 1010 |
| Variance | 85.934838 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 94110 | 17838 | 9.0% |
| 94114 | 13404 | 6.7% |
| 94117 | 11781 | 5.9% |
| 94109 | 11348 | 5.7% |
| 94103 | 10988 | 5.5% |
| 94115 | 10095 | 5.1% |
| 94118 | 9813 | 4.9% |
| 94123 | 9515 | 4.8% |
| 94122 | 8886 | 4.5% |
| 94105 | 8628 | 4.3% |
| Other values (17) | 84898 |
| Value | Count | Frequency (%) |
| 94102 | 7164 | |
| 94103 | 10988 | |
| 94104 | 4229 | 2.1% |
| 94105 | 8628 | |
| 94107 | 7706 | |
| 94108 | 5321 | 2.7% |
| 94109 | 11348 | |
| 94110 | 17838 | |
| 94111 | 5385 | 2.7% |
| 94112 | 7898 |
| Value | Count | Frequency (%) |
| 94158 | 1058 | 0.5% |
| 94134 | 2983 | 1.5% |
| 94133 | 7424 | |
| 94132 | 3507 | 1.8% |
| 94131 | 7665 | |
| 94130 | 81 | < 0.1% |
| 94129 | 23 | < 0.1% |
| 94127 | 4993 | |
| 94124 | 5266 | |
| 94123 | 9515 |
Location
Text
| Distinct | 57604 |
|---|---|
| Distinct (%) | 29.2% |
| Missing | 1700 |
| Missing (%) | 0.9% |
| Memory size | 18.3 MiB |
Length
| Max length | 41 |
|---|---|
| Median length | 40 |
| Mean length | 40.044278 |
| Min length | 35 |
Characters and Unicode
| Total characters | 7897132 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 26164 ? |
|---|---|
| Unique (%) | 13.3% |
Sample
| 1st row | (37.765906581390105, -122.42453043666066) |
|---|---|
| 2nd row | (37.78788490521045, -122.43641930200963) |
| 3rd row | (37.75241643936911, -122.40877419451499) |
| 4th row | (37.77928233382438, -122.48608415176169) |
| 5th row | (37.74224320174262, -122.41981352499106) |
| Value | Count | Frequency (%) |
| 37.79226164705184 | 554 | 0.1% |
| 122.4034859571375 | 554 | 0.1% |
| 37.79294896659241 | 330 | 0.1% |
| 122.39809861435491 | 330 | 0.1% |
| 37.728556952954136 | 281 | 0.1% |
| 122.47676641508518 | 281 | 0.1% |
| 37.77523036414975 | 276 | 0.1% |
| 122.4174703200545 | 276 | 0.1% |
| 37.78977799888473 | 252 | 0.1% |
| 122.40173648131338 | 252 | 0.1% |
| Other values (115177) | 391034 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 899264 | |
| 7 | 893479 | |
| 3 | 736584 | |
| 1 | 703929 | |
| 4 | 698318 | |
| 5 | 534319 | 6.8% |
| 6 | 524243 | 6.6% |
| 8 | 524195 | 6.6% |
| 9 | 523487 | 6.6% |
| 0 | 478844 | 6.1% |
| Other values (6) | 1380470 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7897132 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 899264 | |
| 7 | 893479 | |
| 3 | 736584 | |
| 1 | 703929 | |
| 4 | 698318 | |
| 5 | 534319 | 6.8% |
| 6 | 524243 | 6.6% |
| 8 | 524195 | 6.6% |
| 9 | 523487 | 6.6% |
| 0 | 478844 | 6.1% |
| Other values (6) | 1380470 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7897132 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 899264 | |
| 7 | 893479 | |
| 3 | 736584 | |
| 1 | 703929 | |
| 4 | 698318 | |
| 5 | 534319 | 6.8% |
| 6 | 524243 | 6.6% |
| 8 | 524195 | 6.6% |
| 9 | 523487 | 6.6% |
| 0 | 478844 | 6.1% |
| Other values (6) | 1380470 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7897132 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 899264 | |
| 7 | 893479 | |
| 3 | 736584 | |
| 1 | 703929 | |
| 4 | 698318 | |
| 5 | 534319 | 6.8% |
| 6 | 524243 | 6.6% |
| 8 | 524195 | 6.6% |
| 9 | 523487 | 6.6% |
| 0 | 478844 | 6.1% |
| Other values (6) | 1380470 |
Record ID
Real number (ℝ)
| Distinct | 38347 |
|---|---|
| Distinct (%) | 19.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1620464 × 1012 |
| Minimum | 1.2935322 × 1010 |
|---|---|
| Maximum | 1.49834 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1.2935322 × 1010 |
|---|---|
| 5-th percentile | 1.34534 × 1011 |
| Q1 | 1.30857 × 1012 |
| median | 1.37184 × 1012 |
| Q3 | 1.435 × 1012 |
| 95-th percentile | 1.4859055 × 1012 |
| Maximum | 1.49834 × 1012 |
| Range | 1.4854047 × 1012 |
| Interquartile range (IQR) | 1.2643 × 1011 |
Descriptive statistics
| Standard deviation | 4.9182207 × 1011 |
|---|---|
| Coefficient of variation (CV) | 0.42323788 |
| Kurtosis | 0.55165922 |
| Mean | 1.1620464 × 1012 |
| Median Absolute Deviation (MAD) | 6.322 × 1010 |
| Skewness | -1.5726861 |
| Sum | 2.3114266 × 1017 |
| Variance | 2.4188895 × 1023 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.41585 × 1012 | 11 | < 0.1% |
| 1.34437 × 1012 | 11 | < 0.1% |
| 1.30223 × 1012 | 10 | < 0.1% |
| 1.44093 × 1012 | 10 | < 0.1% |
| 1.45828 × 1012 | 10 | < 0.1% |
| 1.45923 × 1012 | 10 | < 0.1% |
| 1.40362 × 1012 | 10 | < 0.1% |
| 1.39947 × 1012 | 10 | < 0.1% |
| 1.36825 × 1012 | 10 | < 0.1% |
| 1.36952 × 1012 | 10 | < 0.1% |
| Other values (38337) | 198808 |
| Value | Count | Frequency (%) |
| 1.29353215 × 1010 | 1 | |
| 1.295722223 × 1010 | 1 | |
| 1.296226196 × 1010 | 1 | |
| 1.296342101 × 1010 | 1 | |
| 1.296629102 × 1010 | 1 | |
| 1.297286249 × 1010 | 1 | |
| 1.297668221 × 1010 | 1 | |
| 1.297846157 × 1010 | 1 | |
| 1.298230162 × 1010 | 1 | |
| 1.298784182 × 1010 | 1 |
| Value | Count | Frequency (%) |
| 1.49834 × 1012 | 7 | |
| 1.49833 × 1012 | 7 | |
| 1.49832 × 1012 | 7 | |
| 1.49831 × 1012 | 8 | |
| 1.4983 × 1012 | 8 | |
| 1.49829 × 1012 | 9 | |
| 1.49828 × 1012 | 7 | |
| 1.49827 × 1012 | 5 | |
| 1.49826 × 1012 | 5 | |
| 1.49825 × 1012 | 9 |
| Current Status | Estimated Cost | Existing Construction Type | Existing Construction Type Description | Existing Units | Neighborhoods - Analysis Boundaries | Number of Existing Stories | Number of Proposed Stories | Permit Type | Permit Type Definition | Plansets | Proposed Construction Type | Proposed Construction Type Description | Proposed Units | Record ID | Revised Cost | Street Number | Street Number Suffix | Street Suffix | Supervisor District | Unit | Zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Current Status | 1.000 | 0.015 | 0.000 | 0.028 | 0.000 | 0.039 | 0.023 | 0.023 | 0.135 | 0.103 | 0.000 | 0.032 | 0.032 | 0.002 | 0.106 | 0.015 | 0.018 | 0.173 | 0.026 | 0.027 | 0.000 | 0.027 |
| Estimated Cost | 0.015 | 1.000 | -0.073 | 0.000 | 0.009 | 0.009 | 0.099 | 0.117 | -0.208 | 0.149 | 0.259 | 0.021 | 0.021 | 0.008 | 0.025 | 0.884 | -0.020 | 0.000 | 0.000 | 0.012 | 0.006 | -0.030 |
| Existing Construction Type | 0.000 | -0.073 | 1.000 | 0.000 | 0.263 | 0.000 | -0.620 | -0.624 | 0.006 | 0.000 | -0.346 | 0.000 | 0.000 | 0.252 | 0.091 | -0.081 | 0.221 | 1.000 | 0.000 | 0.000 | -0.145 | 0.487 |
| Existing Construction Type Description | 0.028 | 0.000 | 0.000 | 1.000 | 0.115 | 0.326 | 0.307 | 0.311 | 0.070 | 0.401 | 0.000 | 0.994 | 0.994 | 0.115 | 0.085 | 0.000 | 0.094 | 0.073 | 0.111 | 0.269 | 0.118 | 0.248 |
| Existing Units | 0.000 | 0.009 | 0.263 | 0.115 | 1.000 | 0.131 | 0.185 | 0.168 | 0.005 | 0.007 | -0.169 | 0.142 | 0.142 | 0.981 | 0.052 | -0.004 | 0.167 | 0.000 | 0.063 | 0.082 | 0.438 | 0.049 |
| Neighborhoods - Analysis Boundaries | 0.039 | 0.009 | 0.000 | 0.326 | 0.131 | 1.000 | 0.275 | 0.278 | 0.093 | 0.071 | 0.000 | 0.426 | 0.426 | 0.132 | 0.368 | 0.008 | 0.322 | 0.224 | 0.211 | 0.780 | 0.120 | 0.770 |
| Number of Existing Stories | 0.023 | 0.099 | -0.620 | 0.307 | 0.185 | 0.275 | 1.000 | 0.982 | 0.025 | 0.030 | 0.286 | 0.410 | 0.410 | 0.181 | -0.109 | 0.099 | -0.133 | 0.079 | 0.092 | 0.215 | 0.197 | -0.411 |
| Number of Proposed Stories | 0.023 | 0.117 | -0.624 | 0.311 | 0.168 | 0.278 | 0.982 | 1.000 | -0.021 | 0.031 | 0.311 | 0.409 | 0.409 | 0.194 | -0.106 | 0.110 | -0.128 | 0.068 | 0.092 | 0.217 | 0.196 | -0.413 |
| Permit Type | 0.135 | -0.208 | 0.006 | 0.070 | 0.005 | 0.093 | 0.025 | -0.021 | 1.000 | 1.000 | -0.285 | 0.057 | 0.057 | -0.069 | -0.013 | -0.243 | -0.005 | 0.204 | 0.058 | 0.057 | 0.064 | 0.001 |
| Permit Type Definition | 0.103 | 0.149 | 0.000 | 0.401 | 0.007 | 0.071 | 0.030 | 0.031 | 1.000 | 1.000 | 0.000 | 0.049 | 0.049 | 0.015 | 0.023 | 0.162 | 0.015 | 0.204 | 0.044 | 0.043 | 0.000 | 0.043 |
| Plansets | 0.000 | 0.259 | -0.346 | 0.000 | -0.169 | 0.000 | 0.286 | 0.311 | -0.285 | 0.000 | 1.000 | 0.000 | 0.000 | -0.133 | -0.015 | 0.233 | -0.064 | 1.000 | 0.000 | 0.003 | -0.189 | -0.204 |
| Proposed Construction Type | 0.032 | 0.021 | 0.000 | 0.994 | 0.142 | 0.426 | 0.410 | 0.409 | 0.057 | 0.049 | 0.000 | 1.000 | 1.000 | 0.143 | 0.085 | 0.017 | 0.121 | 0.054 | 0.148 | 0.356 | 0.133 | 0.306 |
| Proposed Construction Type Description | 0.032 | 0.021 | 0.000 | 0.994 | 0.142 | 0.426 | 0.410 | 0.409 | 0.057 | 0.049 | 0.000 | 1.000 | 1.000 | 0.143 | 0.085 | 0.017 | 0.121 | 0.054 | 0.148 | 0.356 | 0.133 | 0.306 |
| Proposed Units | 0.002 | 0.008 | 0.252 | 0.115 | 0.981 | 0.132 | 0.181 | 0.194 | -0.069 | 0.015 | -0.133 | 0.143 | 0.143 | 1.000 | 0.053 | -0.007 | 0.168 | 0.000 | 0.064 | 0.087 | 0.437 | 0.029 |
| Record ID | 0.106 | 0.025 | 0.091 | 0.085 | 0.052 | 0.368 | -0.109 | -0.106 | -0.013 | 0.023 | -0.015 | 0.085 | 0.085 | 0.053 | 1.000 | -0.015 | -0.023 | 0.284 | 0.094 | 0.378 | -0.230 | -0.003 |
| Revised Cost | 0.015 | 0.884 | -0.081 | 0.000 | -0.004 | 0.008 | 0.099 | 0.110 | -0.243 | 0.162 | 0.233 | 0.017 | 0.017 | -0.007 | -0.015 | 1.000 | -0.063 | 0.000 | 0.000 | 0.010 | 0.024 | -0.029 |
| Street Number | 0.018 | -0.020 | 0.221 | 0.094 | 0.167 | 0.322 | -0.133 | -0.128 | -0.005 | 0.015 | -0.064 | 0.121 | 0.121 | 0.168 | -0.023 | -0.063 | 1.000 | 0.104 | 0.119 | 0.240 | -0.005 | 0.151 |
| Street Number Suffix | 0.173 | 0.000 | 1.000 | 0.073 | 0.000 | 0.224 | 0.079 | 0.068 | 0.204 | 0.204 | 1.000 | 0.054 | 0.054 | 0.000 | 0.284 | 0.000 | 0.104 | 1.000 | 0.078 | 0.198 | 0.000 | 0.195 |
| Street Suffix | 0.026 | 0.000 | 0.000 | 0.111 | 0.063 | 0.211 | 0.092 | 0.092 | 0.058 | 0.044 | 0.000 | 0.148 | 0.148 | 0.064 | 0.094 | 0.000 | 0.119 | 0.078 | 1.000 | 0.215 | 0.079 | 0.247 |
| Supervisor District | 0.027 | 0.012 | 0.000 | 0.269 | 0.082 | 0.780 | 0.215 | 0.217 | 0.057 | 0.043 | 0.003 | 0.356 | 0.356 | 0.087 | 0.378 | 0.010 | 0.240 | 0.198 | 0.215 | 1.000 | 0.065 | 0.537 |
| Unit | 0.000 | 0.006 | -0.145 | 0.118 | 0.438 | 0.120 | 0.197 | 0.196 | 0.064 | 0.000 | -0.189 | 0.133 | 0.133 | 0.437 | -0.230 | 0.024 | -0.005 | 0.000 | 0.079 | 0.065 | 1.000 | -0.060 |
| Zipcode | 0.027 | -0.030 | 0.487 | 0.248 | 0.049 | 0.770 | -0.411 | -0.413 | 0.001 | 0.043 | -0.204 | 0.306 | 0.306 | 0.029 | -0.003 | -0.029 | 0.151 | 0.195 | 0.247 | 0.537 | -0.060 | 1.000 |
| Permit Number | Permit Type | Permit Type Definition | Permit Creation Date | Block | Lot | Street Number | Street Number Suffix | Street Name | Street Suffix | Unit | Unit Suffix | Description | Current Status | Current Status Date | Filed Date | Issued Date | Completed Date | First Construction Document Date | Structural Notification | Number of Existing Stories | Number of Proposed Stories | Voluntary Soft-Story Retrofit | Fire Only Permit | Permit Expiration Date | Estimated Cost | Revised Cost | Existing Use | Existing Units | Proposed Use | Proposed Units | Plansets | TIDF Compliance | Existing Construction Type | Existing Construction Type Description | Proposed Construction Type | Proposed Construction Type Description | Site Permit | Supervisor District | Neighborhoods - Analysis Boundaries | Zipcode | Location | Record ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | M394467 | 8 | otc alterations permit | 5/15/2013 | 3751 | 172 | 300 | 0 | 03rD | St | NaN | NaN | street space | issued | 5/15/2013 | 5/15/2013 | 5/15/2013 | NaN | 5/15/2013 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.304810e+12 |
| 1 | 2.01505E+11 | 8 | otc alterations permit | 5/22/2015 | 3556 | 6 | 328 | A | gUeRrErO | St | NaN | NaN | remodel (e) bathroom, convert (e) bedrm into bed room and office, all work at ground floor, comply with complaint 200452633. items 3 & 4: existing furnaces to be used. | complete | 12/18/2015 | 5/22/2015 | 6/10/2015 | 12/18/2015 | 6/10/2015 | NaN | 3.0 | 3.0 | NaN | NaN | 6/4/2016 | 18000.0 | 18000.0 | apartments | 3.0 | apartments | 3.0 | 2.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 8 | Mission | 94103.0 | (37.765906581390105, -122.42453043666066) | 1.382530e+12 |
| 2 | M798247 | 8 | otc alterations permit | 6/16/2017 | 655 | 61 | 2426 | A | pInE | St | NaN | NaN | street space permit | issued | 6/16/2017 | 6/16/2017 | 6/16/2017 | NaN | 6/16/2017 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | Pacific Heights | 94115.0 | (37.78788490521045, -122.43641930200963) | 1.467270e+12 |
| 3 | 2.01308E+11 | 8 | otc alterations permit | 8/16/2013 | 4267 | 29 | 2607 | A | bRyAnT | St | NaN | NaN | comply with nov 200009226 and 200346303 remoe e non permitted shed at the rear for unit 2607a. remodel bath, kitchen, new bedroom . unit 2607: remodel bathroom, kitchen, new bedroom, and bath. new lighting and fixtures for both unit | complete | 7/24/2014 | 8/16/2013 | 11/12/2013 | 7/24/2014 | 11/12/2013 | NaN | 2.0 | 2.0 | NaN | NaN | 11/7/2014 | 55000.0 | 80000.0 | apartments | 4.0 | apartments | 4.0 | 2.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 9 | Mission | 94110.0 | (37.75241643936911, -122.40877419451499) | 1.314500e+12 |
| 4 | 2.01307E+11 | 8 | otc alterations permit | 7/26/2013 | 1518 | 37 | 535 | A | 26tH | Av | 0.0 | NaN | replace 2 windows in bathroom not visible; no structural changes max u factor .40 | complete | 12/10/2013 | 7/26/2013 | 7/26/2013 | 12/10/2013 | 7/26/2013 | NaN | 2.0 | 2.0 | NaN | NaN | 7/21/2014 | 1988.0 | 1988.0 | 2 family dwelling | 2.0 | 2 family dwelling | 2.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 1 | Outer Richmond | 94121.0 | (37.77928233382438, -122.48608415176169) | 1.312290e+12 |
| 5 | 2.0161E+11 | 8 | otc alterations permit | 10/17/2016 | 5643 | 42 | 118 | A | vIrGiNiA | Av | NaN | NaN | kitchen remodeling, replace existing cabinets with new units, intsll new sink, faucet, countertop, led lights, install new window, install wall ceiling insulation, drywall, painting. provide plumbing to island | issued | 10/18/2016 | 10/17/2016 | 10/18/2016 | NaN | 10/18/2016 | NaN | 3.0 | 3.0 | NaN | NaN | 10/13/2017 | 8000.0 | 25000.0 | 2 family dwelling | 2.0 | 2 family dwelling | 2.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 9 | Bernal Heights | 94110.0 | (37.74224320174262, -122.41981352499106) | 1.441230e+12 |
| 6 | 2.01406E+11 | 8 | otc alterations permit | 6/11/2014 | 3647 | 6 | 1142 | A | gUeRrErO | St | NaN | NaN | for administrative purposes. to issue certificate of occupancy for final inspection. ref#200302258249. permitted as 1142 guerrero st to be rectified as 1142 a guerrero st. | complete | 5/27/2015 | 6/11/2014 | 6/11/2014 | 5/27/2015 | 6/11/2014 | NaN | 1.0 | 1.0 | NaN | NaN | 6/6/2015 | 1.0 | 1.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 8 | Mission | 94110.0 | (37.752837734228955, -122.4233184555373) | 1.344940e+12 |
| 7 | M619107 | 8 | otc alterations permit | 9/1/2015 | 4143 | 45 | 2662 | A | 22nD | St | 0.0 | NaN | street space permit | issued | 9/1/2015 | 9/1/2015 | 9/1/2015 | NaN | 9/1/2015 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 9 | Mission | 94110.0 | (37.75630632321998, -122.4080145673593) | 1.394150e+12 |
| 8 | M748127 | 8 | otc alterations permit | 12/20/2016 | 1128 | 1 | 1139 | A | sCoTt | St | NaN | NaN | street space permit | issued | 12/20/2016 | 12/20/2016 | 12/20/2016 | NaN | 12/20/2016 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5 | Western Addition | 94115.0 | (37.78025155712736, -122.43783693425848) | 1.447990e+12 |
| 9 | 2.01501E+11 | 8 | otc alterations permit | 1/30/2015 | 1838 | 014A | 1499 | A | 15tH | Av | NaN | NaN | revise pa# 201411171643. change of address on permit. change to 1499a 15th ave. | complete | 2/6/2015 | 1/30/2015 | 1/30/2015 | 2/6/2015 | 1/30/2015 | NaN | 2.0 | 2.0 | NaN | NaN | 1/25/2016 | 1.0 | 1.0 | apartments | 4.0 | apartments | 4.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 7 | Inner Sunset | 94122.0 | (37.760154807972945, -122.4728804480781) | 1.369530e+12 |
| Permit Number | Permit Type | Permit Type Definition | Permit Creation Date | Block | Lot | Street Number | Street Number Suffix | Street Name | Street Suffix | Unit | Unit Suffix | Description | Current Status | Current Status Date | Filed Date | Issued Date | Completed Date | First Construction Document Date | Structural Notification | Number of Existing Stories | Number of Proposed Stories | Voluntary Soft-Story Retrofit | Fire Only Permit | Permit Expiration Date | Estimated Cost | Revised Cost | Existing Use | Existing Units | Proposed Use | Proposed Units | Plansets | TIDF Compliance | Existing Construction Type | Existing Construction Type Description | Proposed Construction Type | Proposed Construction Type Description | Site Permit | Supervisor District | Neighborhoods - Analysis Boundaries | Zipcode | Location | Record ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 198900 | 2.01506E+11 | 8 | otc alterations permit | 6/2/2015 | 7101A | 7 | 736 | NaN | hUrOn | Av | NaN | NaN | reroofing | complete | 3/11/2016 | 6/2/2015 | 6/2/2015 | 3/11/2016 | 6/2/2015 | NaN | 2.0 | 2.0 | NaN | NaN | 5/27/2016 | 6000.0 | 6000.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 11 | Outer Mission | 94112.0 | (37.71192805393076, -122.4500944316179) | 1.383550e+12 |
| 198901 | M871027 | 8 | otc alterations permit | 12/28/2017 | 1870 | 23 | 1514 | NaN | 25tH | Av | NaN | NaN | street space | issued | 12/28/2017 | 12/28/2017 | 12/28/2017 | NaN | 12/28/2017 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4 | Sunset/Parkside | 94122.0 | (37.75921574765919, -122.48300451049278) | 1.492020e+12 |
| 198902 | 2.01609E+11 | 8 | otc alterations permit | 9/20/2016 | 2130A | 006G | 78 | NaN | cRaGmOnT | Av | NaN | NaN | replace (e) tub with walk in tub, 20 amp circuit, gfci outlet | complete | 9/28/2016 | 9/20/2016 | 9/20/2016 | 9/28/2016 | 9/20/2016 | NaN | 2.0 | 2.0 | NaN | NaN | 9/15/2017 | 17900.0 | 17900.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 7 | Inner Sunset | 94116.0 | (37.74973733662819, -122.4671301493082) | 1.438110e+12 |
| 198903 | 2.01407E+11 | 8 | otc alterations permit | 7/16/2014 | 2528 | 24 | 66 | NaN | cReStLaKe | Dr | NaN | NaN | cut a door and a staircase for access to backyard.build deck next to staircase. | complete | 1/23/2015 | 7/16/2014 | 10/28/2014 | 1/23/2015 | 10/28/2014 | Y | 2.0 | 2.0 | NaN | NaN | 10/23/2015 | 4500.0 | 6000.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 2.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 4 | Sunset/Parkside | 94132.0 | (37.73542953855242, -122.48149902038024) | 1.349090e+12 |
| 198904 | M651047 | 8 | otc alterations permit | 12/30/2015 | 6176 | 8 | 342 | NaN | hArKnEsS | Av | NaN | NaN | street space | issued | 12/30/2015 | 12/30/2015 | 12/30/2015 | NaN | 12/30/2015 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 10 | Visitacion Valley | 94134.0 | (37.71765127619624, -122.40342209330782) | 1.407980e+12 |
| 198905 | 2.01604E+11 | 3 | additions alterations or repairs | 4/5/2016 | 7295 | 21 | 3251 | NaN | 20tH | Av | NaN | NaN | ti for space 129,130, 132 partitions, mep, shelving, stonestown mall. ab -56 compliance 2014-0627-9771 | complete | 11/22/2016 | 4/5/2016 | 7/18/2016 | 11/22/2016 | 7/18/2016 | NaN | 2.0 | 2.0 | NaN | NaN | 7/3/2019 | 325000.0 | 928009.2 | retail sales | 0.0 | retail sales | 0.0 | 2.0 | NaN | 2.0 | constr type 2 | 2.0 | constr type 2 | NaN | 7 | Lakeshore | 94132.0 | (37.728556952954136, -122.47676641508518) | 1.418500e+12 |
| 198906 | 2.0151E+11 | 8 | otc alterations permit | 10/27/2015 | 4009 | 001A | 1919 | NaN | mArIpOsA | St | NaN | NaN | install new 2" underground combination fire main. ref app#201402108156 | issued | 10/27/2015 | 10/27/2015 | 10/27/2015 | NaN | 10/27/2015 | NaN | 3.0 | 3.0 | NaN | Y | 10/21/2016 | 1200.0 | 9600.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 2.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 10 | Potrero Hill | 94107.0 | (37.76328445631136, -122.40287014554292) | 1.400890e+12 |
| 198907 | 2.01607E+11 | 8 | otc alterations permit | 7/29/2016 | 4262 | 20 | 1341 | NaN | sAn bRuNo | Av | NaN | NaN | replace rotten wooden moldings in kind front stairs less than 50% replace | issued | 7/29/2016 | 7/29/2016 | 7/29/2016 | NaN | 7/29/2016 | NaN | 2.0 | 2.0 | NaN | NaN | 7/24/2017 | 1900.0 | 1900.0 | 1 family dwelling | 1.0 | 1 family dwelling | 1.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 10 | Mission | 94110.0 | (37.75260530951628, -122.40400191084352) | 1.431900e+12 |
| 198908 | 2.01701E+11 | 8 | otc alterations permit | 1/6/2017 | 146 | 7 | 660 | NaN | bRoAdWaY | NaN | NaN | NaN | revision to pa 2016-0926-8773; remove (e) storefront & doors, remove floor, ceiling & wall finishes for new. new storefront, (n) wall & ceiling finishes, (n) flooring with waterproofing in a (n) alcove. mep under pa#201503100377 | issued | 2/1/2017 | 1/6/2017 | 2/1/2017 | NaN | 2/1/2017 | NaN | 2.0 | 2.0 | NaN | NaN | 1/27/2018 | 1.0 | 1.0 | retail sales | 9.0 | retail sales | 9.0 | 2.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 3 | Chinatown | 94133.0 | (37.79800446861674, -122.4080339831039) | 1.449660e+12 |
| 198909 | 2.01604E+11 | 8 | otc alterations permit | 4/25/2016 | 3708 | 56 | 525 | NaN | mArKeT | St | NaN | NaN | 16th floor - (4) evacuation plans. | issued | 4/25/2016 | 4/25/2016 | 4/25/2016 | NaN | 4/25/2016 | NaN | 38.0 | 38.0 | NaN | Y | 4/20/2017 | 1600.0 | 1600.0 | office | 0.0 | office | 0.0 | 2.0 | NaN | 1.0 | constr type 1 | 1.0 | constr type 1 | NaN | 6 | Financial District/South Beach | 94105.0 | (37.79040639954478, -122.39927546096968) | 1.420790e+12 |
Most frequently occurring
| Permit Number | Permit Type | Permit Type Definition | Permit Creation Date | Block | Lot | Street Number | Street Number Suffix | Street Name | Street Suffix | Unit | Unit Suffix | Description | Current Status | Current Status Date | Filed Date | Issued Date | Completed Date | First Construction Document Date | Structural Notification | Number of Existing Stories | Number of Proposed Stories | Voluntary Soft-Story Retrofit | Fire Only Permit | Permit Expiration Date | Estimated Cost | Revised Cost | Existing Use | Existing Units | Proposed Use | Proposed Units | Plansets | TIDF Compliance | Existing Construction Type | Existing Construction Type Description | Proposed Construction Type | Proposed Construction Type Description | Site Permit | Supervisor District | Neighborhoods - Analysis Boundaries | Zipcode | Location | Record ID | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.01302E+11 | 4 | sign - erect | 2/5/2013 | 14 | 1 | 250 | NaN | bEaCh | St | NaN | NaN | to attach signs to existing awning | complete | 9/18/2013 | 2/5/2013 | 2/5/2013 | 9/18/2013 | 2/5/2013 | NaN | 4.0 | NaN | NaN | NaN | 1/31/2014 | 10000.0 | 10000.0 | retail sales | NaN | NaN | NaN | 2.0 | NaN | 1.0 | constr type 1 | NaN | NaN | NaN | 3 | North Beach | 94133.0 | (37.80805300064998, -122.41324762431046) | 1.295230e+12 | 4 |
| 59 | 2.01609E+11 | 4 | sign - erect | 9/21/2016 | 7295 | 21 | 3251 | NaN | 20tH | Av | NaN | NaN | victoria's secret wall mounted electrical single faced wall sign | issued | 9/21/2016 | 9/21/2016 | 9/21/2016 | NaN | 9/21/2016 | NaN | 2.0 | NaN | NaN | NaN | 9/16/2017 | 2000.0 | 2000.0 | retail sales | NaN | NaN | NaN | 2.0 | NaN | 2.0 | constr type 2 | NaN | NaN | NaN | 7 | Lakeshore | 94132.0 | (37.728556952954136, -122.47676641508518) | 1.438210e+12 | 4 |
| 78 | 2.01711E+11 | 4 | sign - erect | 11/27/2017 | 353 | 1 | 200 | NaN | lArKiN | St | NaN | NaN | to erect one non-electric, non-illuminated, single faced, wall sign. | filed | 11/27/2017 | 11/27/2017 | NaN | NaN | NaN | NaN | 4.0 | NaN | NaN | NaN | NaN | 3000.0 | NaN | museum | 0.0 | NaN | NaN | 2.0 | NaN | 1.0 | constr type 1 | NaN | NaN | NaN | 6 | Tenderloin | 94102.0 | (37.78021549250912, -122.41602577118189) | 1.488290e+12 | 4 |
| 0 | 2.01302E+11 | 4 | sign - erect | 2/11/2013 | 3930A | 2 | 2300 | NaN | 16tH | St | NaN | NaN | install one illuminated wall sign for "vitamin shoppe" | complete | 6/26/2013 | 2/11/2013 | 2/28/2013 | 6/26/2013 | 2/28/2013 | NaN | 2.0 | NaN | NaN | NaN | 2/23/2014 | 2000.0 | 2000.0 | retail sales | 0.0 | NaN | NaN | 2.0 | NaN | 1.0 | constr type 1 | NaN | NaN | NaN | 10 | Mission | 94103.0 | (37.76660897553399, -122.40911776717232) | 1.295810e+12 | 3 |
| 10 | 2.01309E+11 | 4 | sign - erect | 9/17/2013 | 1517 | 37 | 6333 | NaN | gEaRy | Bl | NaN | NaN | erect electric sign | complete | 11/19/2013 | 9/17/2013 | 9/17/2013 | 11/19/2013 | 9/17/2013 | NaN | 1.0 | NaN | NaN | NaN | 9/12/2014 | 6500.0 | 6500.0 | retail sales | 0.0 | NaN | NaN | 2.0 | NaN | 3.0 | constr type 3 | NaN | NaN | NaN | 1 | Outer Richmond | 94121.0 | (37.779635697353044, -122.48739021723274) | 1.317860e+12 | 3 |
| 26 | 2.01404E+11 | 2 | new construction wood frame | 4/25/2014 | 6243 | 19 | 590 | NaN | lElAnD | Av | NaN | NaN | to erect 3 stories, no basement, single family dwelling. | filed | 4/25/2014 | 4/25/2014 | NaN | NaN | NaN | NaN | NaN | 3.0 | NaN | NaN | NaN | 350000.0 | NaN | NaN | NaN | 1 family dwelling | 1.0 | 2.0 | NaN | NaN | NaN | 5.0 | wood frame (5) | Y | 10 | Visitacion Valley | 94134.0 | (37.71511329299603, -122.41528882720623) | 1.339820e+12 | 3 |
| 55 | 2.01608E+11 | 2 | new construction wood frame | 8/4/2016 | 5377 | 71 | 159 | NaN | cHaRtEr oAk | Av | NaN | NaN | erect 3 story, no basement, single family dwelling. | filed | 8/4/2016 | 8/4/2016 | NaN | NaN | NaN | NaN | NaN | 3.0 | NaN | NaN | NaN | 300000.0 | NaN | NaN | NaN | 1 family dwelling | 1.0 | 2.0 | NaN | NaN | NaN | 5.0 | wood frame (5) | Y | 10 | Bayview Hunters Point | 94124.0 | (37.73537008200893, -122.404282097856) | 1.432500e+12 | 3 |
| 94 | M602288 | 8 | otc alterations permit | 7/9/2015 | 1859A | 11 | 40 | NaN | lUrLiNe | St | NaN | NaN | NaN | issued | 7/9/2015 | 7/9/2015 | 7/9/2015 | NaN | 7/9/2015 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 7 | Inner Sunset | 94122.0 | (37.75941893593247, -122.47089493049447) | 1.387960e+12 | 3 |
| 2 | 2.01302E+11 | 4 | sign - erect | 2/5/2013 | 14 | 1 | 250 | NaN | bEaCh | St | NaN | NaN | to erect 3 blade signs with intergrated lighting, signs facing jefferson | complete | 9/17/2013 | 2/5/2013 | 2/5/2013 | 9/17/2013 | 2/5/2013 | NaN | 4.0 | NaN | NaN | NaN | 1/31/2014 | 10000.0 | 10000.0 | retail sales | 0.0 | NaN | NaN | 2.0 | NaN | 1.0 | constr type 1 | NaN | NaN | NaN | 3 | North Beach | 94133.0 | (37.80805300064998, -122.41324762431046) | 1.295290e+12 | 2 |
| 3 | 2.01302E+11 | 8 | otc alterations permit | 2/1/2013 | 6280 | 43 | 806 | NaN | rUsSiA | Av | NaN | NaN | install shake vinyl siding on back of house only not visible from the street . no structural changes | complete | 5/8/2013 | 2/1/2013 | 2/1/2013 | 5/8/2013 | 2/1/2013 | NaN | 3.0 | 3.0 | NaN | NaN | 1/27/2014 | 7935.0 | 7935.0 | 2 family dwelling | 2.0 | 2 family dwelling | 2.0 | 0.0 | NaN | 5.0 | wood frame (5) | 5.0 | wood frame (5) | NaN | 11 | Excelsior | 94112.0 | (37.71823948380821, -122.43070649984861) | 1.294940e+12 | 2 |